>Hi All:
> I have two sql servers. One is for development and the other one is for production. I want to import my data from production server into development server. I try to used to import from Server Enterprise Manager to import the data from production to development, however I go an login error: "Not associated with trusted Sql Server." I selected Use Windows NT Authentication option from DTS. What do I need to do to import the data into my development server.
>Thanks

Assuming you can get past that permissions error, open up the Import and Export wizard in the SQL Server group and after selecting source and destination databases, select "Transfer all objects" to create a copy of the production db to your development server/workstation. HTH