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.
| Author |
Topic |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2008-05-30 : 11:15:16
|
| Hi Gurus,I am running a profiler with colomn filters as following..Textdata : Procedure name with parameters.NTUsername :Username.And i starting executing procedure.And runing profiler with above metioned details,But iam not able to view any trace on this.Am i doing someting wrong here ..please advice..Thanks,ServerTeam |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-30 : 11:23:23
|
| Did you check events for Stored Procedure? |
 |
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-05-30 : 11:27:49
|
| sorry ..i am not clear with you..Thanks,ServerTeam |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-05-30 : 11:30:03
|
| in profiler there are SP events that you have to subscribe to to view stored procedure activity._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-30 : 11:59:51
|
| Add SP:Completed to the trace. If you add the others such as the starting event, you'll get duplicates which can be annoying.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|
|
Running profiler on Procedure