>I have been working with the import wizard in SQL 05, pulling data from SQL 2K. The data comes across, but the primary key and index definitions are not there. Am I missing something??
>
The SQL Server Import Wizard main purpose is to copy data from a source to a destination. It's up to you to make sure that table definitions, including indexes, FK, CK, etc., on the destination are correct.
You may want to use the Copy Database Wizard instead if you're transfering whole DB.
--sb--