We have installed in on several servers, both W2k and W2k3, and have only found one problem.

When SQLDiag is run, it fails with a C++ Runtime Library error:

Buffer overrun detected

Anyone...

I had the same problem, then got trapped with it set to single user mode (argh!)

I rebooted the machine, then realized my

application had several OS services that auto-magically connected...

I think I found the trick, this appears to work:

CREATE PROCEDURE testprocedure AS

SELECT OBJECT_NAME(@@ProcID) as ProcedureName

GO

EXEC testprocedure

GO