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?
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.