Hi Folks,
I'm hoping to find a centralized way to capture the SQL generated by clients running against an MS SQL Server (similar to what you can do via the audit functions in Sybase). Is there any way to use the Profiler or some other tool to configure capture of the SQL that a client sends to the server? I need to grab this to look for a specific pattern in the SQL--I'm trying to do something special when it does a particular partern of a SELECT followed by no UPDATE (hence a trigger won't do it--there's no operation I can hang the trigger on--and the pattern in question is several statements, not a single one).
A quick read of the Profiler documentation didn't reveal any way to enable capture of the actual SQL that one or more users or clients generate. Did I miss something? Is there another option that comes to mind?
Thanks much!
John
John Craig
Alpha-G Consulting, LLC
I'm hoping to find a centralized way to capture the SQL generated by clients running against an MS SQL Server (similar to what you can do via the audit functions in Sybase). Is there any way to use the Profiler or some other tool to configure capture of the SQL that a client sends to the server? I need to grab this to look for a specific pattern in the SQL--I'm trying to do something special when it does a particular partern of a SELECT followed by no UPDATE (hence a trigger won't do it--there's no operation I can hang the trigger on--and the pattern in question is several statements, not a single one).
A quick read of the Profiler documentation didn't reveal any way to enable capture of the actual SQL that one or more users or clients generate. Did I miss something? Is there another option that comes to mind?
Thanks much!
John
John Craig
Alpha-G Consulting, LLC
