Home » 2012 (Page 3)
Yearly Archives: 2012
How to open and view a deadlock graph .xdl file with SSMS ?
How to open and view a deadlock .xdl file with SSMS ? Solution 1 : On the File menu in SQL Server Management Studio, point to Open, and then click File. In the Open File dialog box, select your .xdl file & click open. Solution 2 : Go to the directory, you have saved your … Continue reading
SQL Server 2012 SP1 Is Now Available !
After a wait of around 8 months, Microsoft has released SQL Server 2012 SP1. Microsoft SQL Server team has released SQL Server 2012 Service Pack 1 (SP1). Both, the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. SQL Server 2012 SP1 contains fixes to issues. It includes all … Continue reading
How to save deadlock graph events as .xdl file in SQL Server ?
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
SQL Server – List of all the Error codes or messages
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
Come Back From vacations…..
Hey Friends I missed you so much in my vacations. I come back from my leaves & hope now we have regular interactions.