That helps, only minor change will fit my need , thanks a bundle.:)

Thanks, guys, but i found a better way, share with you guys:

tasklist /svc /fi "imagename eq sqlservr.exe"

run the above command and get relationship between PID and service name, ...

Haidong,

You are right in your sense, I think we are just not in the same page for the same question, my original concern is :

if you put the sp in...

No, Haidong, I don't agree with you on "When you start SQL Agent, SQL Server Service will be started automatically, as SQL Agent service is dependent on SQL Server service."

For...

Haidong, thank you for your reply.

I used the extended stored procedure created a couple of trace running on SQL 7, we are in the process of upgrading to SQL 2000.

In...

Haitong, how to make your script to do the trace automatically whenever the server is reboot ?