Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

MSSQLFUN

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

Archives: September 2012

Check List for SQL Server Connectivity Issue !

SQL Server connectivity is the most common issue & below mention errors is also common at time of connectivity issue.

Error :

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is… Read more

2 comments, 234 reads

Posted in MSSQLFUN on 28 September 2012

SP_HELPTEXT showing old Store Procedure name after rename, is it a Bug?

Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He is sharing a problem with Sp_Helptext. He is considering it as a Bug.

Try to rename any procedure in your database by right click. Then modify it. SSMS will… Read more

0 comments, 119 reads

Posted in MSSQLFUN on 26 September 2012

SQL Server || Change Batch separator

SQL Server utilities interpret GO as a keyword to separate the batch. GO is not a Transact-SQL statement. it is a keyword or command recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code.

Customizing Changing the Batch separator in SSMS

Steps to customize the batch separator… Read more

0 comments, 190 reads

Posted in MSSQLFUN on 25 September 2012

Upgrade SQL Server 2005 Full-Text Catalog to SQL Server 2012……By Detach & Attach…….Part 2 of 2

Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.

We have copied the database from SQL Server 2005 having MDF, LDF & full-text catalog that is required for upgrading & importing a SQL Server 2005 full-text catalog into SQL Server… Read more

0 comments, 156 reads

Posted in MSSQLFUN on 21 September 2012

Upgrade SQL Server 2005 Full-Text Catalog to SQL Server 2012……By Backup & Restore…….Part 1 of 2

Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.

The full database backup will include the full-text catalog is required for upgrading & importing a SQL Server 2005 full-text catalog.

Backup from SQL Server 2005

When the database is restored… Read more

0 comments, 192 reads

Posted in MSSQLFUN on 19 September 2012

How to log SQL Server Custom Error in Windows Event Log ?

SQL server gives an option to log custom errors in windows event log. We have 2 options of achieving this.

Option 1 : Using xp_logevent

BEGIN TRY

SELECT 10/0

END TRY

BEGIN CATCH

PRINT ERROR_Message()

DECLARE @msg VARCHAR(100)

SELECT @msg = ERROR_Message()

–xp_logevent error_number , errormessage, severity (INFORMATIONAL, WARNING, or… Read more

0 comments, 142 reads

Posted in MSSQLFUN on 17 September 2012

Surface Area Configuration tool available in SQL Server 2008 & onwards

Surface area configuration is a security measure that involves stopping or disabling unused components. Surface area configuration helps to improve security by providing fewer avenues for potential attacks on a system.

Surface Area Configuration too is introduced in SQL Server 2005 & Direct access of Surface Area Configuration tool has… Read more

1 comments, 234 reads

Posted in MSSQLFUN on 14 September 2012