monitor progress of store procedure through sql statements

[Guest_imported]

I was wondering if it is possible to monitor the progress of a store procedure that has been executed, or just retrieve general info about this executed job, through sql statements. If so, then how can I accomplish this??

Thanks in advance
sqlNubie

 

[aalmeida]

Have you tryed trace the connection? AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[Guest_imported]

what do you mean by that,
could you give me an example?

thanks

 

[aalmeida]

A trace is a monitoring action that colects event information and displays it. If you are not familiar with this kind of scripts the best would be for you to use SQL Profiler to do that. SQL Profiler comes with SQL server package and is installed as default, you can find it at the same place you can find sql server on the Windows Menu.
You'll be able to find more info at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_mon_perf_6koi.asp

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"