<div>
CREATE Proc sp_getlocks<br />
<br />
I'm sure this will answer your questions...<br />
<a href="http://articles.techrepublic.com.com/5100-9592_11-6088055.html" rel="ugc">http://articles.techrepublic.com.com/5100-9592_11-6088055.html</a><br />
<br />
alittle more you.<br />
&nbsp;<a href="http://msdn2.microsoft.com/en-us/library/ms187749.aspx" rel="ugc">http://msdn2.microsoft.com/en-us/library/ms187749.aspx</a> as well as doing a google search for more information on lock types, etc.<br />

</div>


<div>
I have seen all these links. &nbsp;just not sure how to put it all in a nice simple script..
</div>


<div>
Does not alert me. &nbsp; I am looking for some form of alert so that we ca resolve the issue before users start calling<br />
1. a lock occurs on &nbsp;database &nbsp;<br />
2. The head of the blocking chain or who is causing the locking/blocking<br />
3. the query that the spid that is blocking is running....<br />

</div>


<div>
<div class="content wysiwyg-content">
I need a script that can send an email to Ohemaa@yahoo.com when <br />
there is <br />
<br />
1. a lock on the database Customer &nbsp;<br />
2. The head of the blocking chain<br />
3. the query that the spid that is blocking is running....<br />
<br />

</div>
</div>


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


CREATE Proc sp_getlocks

I&#39;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.


I have seen all these links.  just not sure how to put it all in a nice simple script..

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


Db Blocking/Locking

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.