patternsqlMinor
Verify Query Request Received
Viewed 0 times
requestqueryreceivedverify
Problem
I have a software system which queries data via OLEDB from an external SQL Server 2005. The query request is sent every 15 minutes. I want to verify that the SQL Server is receiving the query requests. How can I?
Solution
Create a SQL Trace (server-side) and capture the SQL:StmtCompleted event. You can filter on the
The easiest way to create a server-side trace would be to create it in SQL Server Profiler (which is innately a client-side trace), do a quick start and stop and script out the trace definition and run it in SSMS. Please see this TechNet reference on Server-Side Tracing and Collection for an exhaustive reference on the details how to do this.
TextData column to ensure you're only getting the query that you are looking to ensure is happening.The easiest way to create a server-side trace would be to create it in SQL Server Profiler (which is innately a client-side trace), do a quick start and stop and script out the trace definition and run it in SSMS. Please see this TechNet reference on Server-Side Tracing and Collection for an exhaustive reference on the details how to do this.
Context
StackExchange Database Administrators Q#43450, answer score: 2
Revisions (0)
No revisions yet.