Browsing articles from "June, 2012"
Jun
29
2012

Changing SQL Server Collation / Rebuilding system databases

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 […]

Jun
7
2012

SQL 2005/2008/R2 N/W connection error troubleshooting steps

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)   • […]

Jun
1
2012

task completed with exit code of (1)

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 […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 25 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

June 2012
M T W T F S S
« May   Jul »
 123
45678910
11121314151617
18192021222324
252627282930  

View Post by Categories

%d bloggers like this: