• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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