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...
2012-11-09
2,372 reads
MSSQLFUN
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...
2012-11-08
958 reads
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...
2012-11-14 (first published: 2012-11-07)
3,620 reads
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...
2012-11-05
34,216 reads
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.
2012-11-05
548 reads
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...
2012-10-16
765 reads
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...
2012-10-15
3,000 reads
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...
2012-10-15
593 reads
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....
2012-10-12
1,084 reads
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...
2012-10-11
735 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers