Viewing 4 posts - 46 through 49 (of 49 total)
ok, thanks.
But, this just runs in over 5 secs on a test server.
The only difference is that there are other processes that are running on the prod server. (which Im...
October 29, 2010 at 12:08 pm
#1244372
Attached is a snippet of the proc (rather large)
Thank you.
October 29, 2010 at 9:39 am
#1244289
Thanks Craig.
I did what you adviced, and found about 1000 entries in the sp_loc got the process, but all of them had a GRANT status.
Also, the sysprocesses table did not...
October 28, 2010 at 6:31 pm
#1243947
Thanks for the advice, Craig.
Can you shed little more light on this, is there a way I can do it in the Profiler at all?
October 28, 2010 at 3:08 pm
#1243859