#sql server profiler

[thedbahub]

Identifying Applications Writing to a Table in SQL Server: Strategies and Tools

Determining which applications are writing to a given table in SQL Server can be approached in several ways, depending on your access level, the tools you have at your disposal, and whether you need to monitor this activity in real-time or over a period. Here are some methods to consider: 1. SQL Server Profiler / Extended Events SQL Server Profiler and Extended Events are tools for monitoring…

View On WordPress

[sandeep2363]

Trace the failed Queries in SQL profiler for MSSQL Server

Trace the failed Queries in SQL profiler for MSSQL Server

Check procedure and Queries in SQL Profiler for MSSQL Server Open the SQL Server Profiler direct OR Open from SQL Management Studio —> Go to tool –> Select SQL Server Profiler.Connect with the Server on which you want to connect for tracing with Servername, username and password.Open a Trace Properties window –> General tab, for Use the template field select Standard.( Default)Check on the file…

View On WordPress