var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I must create (with sql Server 2000) a alert wich notify me if a transaction has exceed a precise interval of time (30 sec).
How can i do?
With T-sql you have use @@spid, then save data from sp_who2 in a temporary table with a cursor. Use a count variable in your cursor and when that value becomes big enough your transaction has been going to long and now you can raierror….
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors