[Saludalabs]

Hi all,

I have the full addition of SQL 2005 installed on my machine and I Have two questions:

1. I register a sql server in the Registered Server window with username/password, and able to connect to the servers without having to enter my username/password. However, if I attempt to use the Import and Export Wizard I have to enter my username passord for SQL server authenitcations everytime.

How do I get the Management Studio to remember my username/password in the Import/Export Wizard?

2. I remember in SQL 2000 I could move tables back end forth between live and development server with no problems. With Studio Management I have to drop a table before importing it from the other sql server.

Is there easier way to do this in Server Management Studio? or What is a better way (best practice) to update my dev server with the live data?

Thanks,
David

PS: Can I post my blog address after my signature? I am new to this forum.