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...

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...

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...

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...

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.

SQL Server 2012 CU4 Is Now Available !

The 4thcumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update...

Multilanguage Table, How to insert different language text in table ?

Issue :
Today, I received one request from my old friend.
He wants to insert text in different languages in table. He...

IMPORTANT MESSAGE || http://MSSQLFUN.WORDPRESS.COM is now http://MSSQLFUN.COM

Dear Friends
Firstly, I want to say thanks for your support & liking my blogs that make it possible.
I like to share...

How to move the FullText catalog with SQL Server 2005 ?

4 simple steps to move FullText catalog with SQL Server 2005 :-
1. Detach the database which contains the FullText Catalog....

SQL Server 2012 SP1 CTP4 Is Now Available !

Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view.
Microsoft has...