Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Profiler

Author  Topic 

kappa02
Yak Posting Veteran

65 Posts

Posted - 2009-04-29 : 10:01:29
Is there a (using Profiler) way which I can tell what stored procedures & VB programs are being excuted when I'm running something? I can tell what proc's are being used in the TextData field running Profiler But I also want VB programs & any other calling modules as well.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-29 : 11:08:48
You can get the programs in the ApplicationName column, but they must've set that value in their connection property in order for us to see the value in SQL Profiler.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -