Home » SQL Server (Page 43)
Category Archives: SQL Server
Why SQL Server Named Instance connect without specifying instance name ?
Issue : Today Evening, I was just about to leave the office and at same time I got a call from one of my friend. He is not running under any production issue but bit confused with SQL server behavior while connecting with port no. in case of named instance. He is having one named … Continue reading
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