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

Attached is a snippet of the proc (rather large)

Thank you.

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

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?

Thank you.