Category Archives: CodeProject

How to save deadlock graph events as .xdl file ? On the File menu, click New Trace, and then connect to an instance of SQL Server. In the Trace Properties dialog box, type a name for the trace in the Trace name box. In the Use the template list, select a trace template on which … Continue reading →

Question: I want list of all error codes & messages of SQL server. Answer: Once some ask this thing to you or this though comes to your mind, I am sure most of us will start goggling or looking into BOL for the details But SQL server also Contains one row for each system error … Continue reading →

The 4thcumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update 4 contains all the SQL Server 2012 hotfixes which have been available since the initial release of SQL Server 2012. This update contains hotfixes for issues that were fixed after the release of SQL Server … Continue reading →

Issue : Today, I received one request from my old friend. He wants to insert text in different languages in table. He is looking to create Multilanguage table. Solution : The simplest solution is to insert data in table as NVARCHAR data type, like below. –Create Table CREATE TABLE TBL_LANG ( LNAME VARCHAR(50), LTXT NVARCHAR(100) … Continue reading →

4 simple steps to move FullText catalog with SQL Server 2005 :- 1. Detach the database which contains the FullText Catalog. While detaching from Management Studio, there is “check box” called “Keep FullText Catalogs”. Make sure that this is selected. 2. Move the catalog files to the location where you want them. 3. Attach the … Continue reading →