If you are search for backup files then also give .dmp in your search criteria..

Thanks Vidhya

What you mean by common column??

Try using

xp_cmdshell 'netstat -an'

xp_cmdshell 'ipconfig /all'

Thanks for the information GILA

Shrink tempdb.Thats the only way to get rid of this

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 🙂