|
Posted by laurenq uantrell on 09/30/83 11:27
The next step is to run this every 60 seconds and export the results to
a text file using bcp...
I know that in my original post:
SELECT
SPID,
loginame
FROM master.dbo.sysprocesses
WHERE
BlkBy > 0
will get the ball rolling if a blocking situation exists.
But looking at your aba_lockinfo sproc I'm not sure where to start
something like:
if exists (SELECT * FROM master.dbo.sysprocesses WHERE BlkBy > 0)
begin
/* Blocking exisit so use Erland's aba_lockinfo sproc to BCP to a
text file */
end
Navigation:
[Reply to this message]
|