jack786
13th July 2004, 09:42
In oracle we have a varaible Env variable called ORAPROF.Can body tell me the similar one for MS SQLServer 2000 or 7??

rgds,
jack
dave_23
13th July 2004, 13:41
SQLPROF

But its ugly in level1..

Dave
Dikkie Dik
15th July 2004, 09:53
The right parameter is MSQLPROF. But you can also use the Profiler of SQL Server.

Kind regards,
Dick
dave_23
15th July 2004, 13:35
That'll teach me to answer off the top of my head w/o checking my notes!

Dave