You may find yourself in situation where you need to change Server level collation or need to rebuild system databases, then following article will be helpful, 1. First detach all user databases 2. Script any logins (if exists) using sp_help_revlogin (get one from MSDN for e.g. http://support.microsoft.com/kb/246133 , http://support.microsoft.com/kb/918992 3. Script Maintenance plans/Jobs (if can’t be created again) 4. Execute following on command line by going to the folder where appropriate setup of SQL Server […]

You may see 1001 n/w connection error when trying to connect remote sql server from ssms, I have compiled some best troubleshooting steps I am aware and few collected from various references,   First try to use one of five ways to connect SQL Server using SSMS, (for e.g. let’s say server name is ngmssql and instance name is sql001 and domain is ad.in.com and port is 1433 and ip address is 10.26.27.28)   • […]

While executing a batch job (which I calling other files) using windows scheduler you may start receiving error as (in scenario where your job was running absolutely fine, this error started occurring suddenly),   task completed with exit code of (1)   Now on further investigation, found a link to describe the meaning of code,   0x0: The operation completed successfully. 0x1: An incorrect function was called or an unknown function was called. 0xa: The […]