I had this issue when trying to drop the login of a person that had done an AOAG install\config. That login had granted connect permission to the HADR endpoint for...

Hello Krystian,

With the exception of changing @recipients and @profile_name, I ran your script just as you posted it. I ran the first part creating sp_DetectLongRunningTransactions. I...

Thank you Krystian, I'm testing out your script. When no queries are running it completes successfully, when I kick off a test query and then run it I get...

As you noted, using that counter only tracks transactions with "read committed snapshot isolation level." Does anyone know of a way to monitor and alert on ANY long running...

This error message from two databases was flooding the SQL error log on one of my servers and the error logs were getting huge eating up disk space. I...

Last night while migrating a 2TB database we came across the same issue:

Database 'DBname' cannot be opened. It is in the middle of a restore.

Error: 927, Severity: 14, State: 2.

A...

I found two solutions to this problem.

I am testing log shipping on our test server in SQL 2005. In this test environment, there are no active transactions happening. ...

Hello Gail, I know this post is old but what you mentioned relates directly to our issue. This isn't a major issue, just annoying. My customer has...