• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 427
  • Last Modified:

How do you create a SQL Profiler trace that will check if any stored procedure with 'tracking' in the SP name is executed?

Hi Guys,
How does one create a SQL Server profiler trace that will check, if any stored procedure which has the string 'tracking' in it's name, is executed?

Thanks
0
Barry Cunney
Asked:
Barry Cunney
1 Solution
 
reb73Commented:
You could try creating a new trace using the template 'SQLProfilerTSQL_SPs' and then add a filter under TextData -> Like '%tracking%'.

This could possibly capture any parameter values with the pattern '%tracking%' as well though..
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now