Category Archives: SQL Server

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 show changed name. But when … Continue reading →

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 in SSMS: Launch SSMS Go … Continue reading →

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 2012. Database files from SQL Server … Continue reading →

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 on SQL Server 2012, a new … Continue reading →

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 ERROR) EXEC xp_logevent 60000, @msg, … Continue reading →