As far as i know you can set a login to expire ,only password is set to expire for a particular login..

Enable remote connection for the server and use tcp ip and named pipes...

Which version of sql server you are using???

Creating index on a table with no data is waste of time.As you mentioned you have primary keys defined which creates a clustered index on the table.For long queries you...

Have you given any alias name for the Servers???

Thanks alot DAVID 😀

Detach your MDF files copy them to D drive and attach them.

Hope this will help

http://msdn.microsoft.com/en-us/library/ms190794.aspx

Run dbcc checkdb after detach, attach

Those scripts are for 2000:sick:.Am having SQL Server 2005 Express so how can i script out all logins other than doing one by one .

Thanks Perry 🙂

Am with Jack 😀 ..Thats the way you can do ...

Create a secondary datafile on your D drive and then move some tables to that location

Thanks for reply,

1)How to backup...

IMPORT/EXPORT is there in 2000 and 2005 .Error file in bcp is that the those data which are not able to get inserted into the new table will go to...

Is there any option in SQL Server IMPORT/EXPORT like error file in BCP

What are all the ways to migrate a database from 2000 to 2005??

Check whether you have enough disk space at those instance of time.