We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

Db Blocking/Locking

ohemaa
ohemaa asked
on
531 Views
Last Modified: 2012-05-05
I need a script that can send an email to Ohemaa@yahoo.com when
there is

1. a lock on the database Customer  
2. The head of the blocking chain
3. the query that the spid that is blocking is running....

Comment
Watch Question

CREATE Proc sp_getlocks

I'm sure this will answer your questions...
http://articles.techrepublic.com.com/5100-9592_11-6088055.html

alittle more you.
 http://msdn2.microsoft.com/en-us/library/ms187749.aspx as well as doing a google search for more information on lock types, etc.

Author

Commented:
I have seen all these links.  just not sure how to put it all in a nice simple script..
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Does not alert me.   I am looking for some form of alert so that we ca resolve the issue before users start calling
1. a lock occurs on  database  
2. The head of the blocking chain or who is causing the locking/blocking
3. the query that the spid that is blocking is running....
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.