I have recently been working with a COM+ component that processes an input XML file, and makes a number of database updates based on the suppli开发者_开发问答ed data.
I have a set of rollover .trc files recorded with Sql Profiler. mytrace.trc mytrace_1.trc mytrace_2.trc mytrace_3.trc
I am trying to identify SQL INSERTS that occur when a record is viewed from a Windows application. In SQL Profiler I have a long list of stored procedures that fire when the record is viewed, however
I\'m running a data import (using C#/Linq), and naturally I\'m trying to optimize my queries as much as possible.To this end I\'m running a trace on the DB using SQL Server Profiler, with my trace fi开
In SQL Profile开发者_StackOverflow中文版r 2005, is it possible to capture a result set in a SQL trace, so that I could see corresponding queries with result sets?...Or is it only a one way trace?
I\'m trying to debug a deadlock with SQL Server Profiler 2008. I know how to get a graph of the deadlock in the profiler, but when I hover over one of the two statements in shown in the graph, the \"S
We\'re running a Citrix farm and I\'m trying to track heavy users of our DB, I can get the PID of the process from Sql Profiler but I then need to laboriously search for that PID in each server in the
i need to clearly see what IP address made what sql query to SQL server. I am trying to use SQL Profiler, but it seems there is no way i can somehow to differentiate the machine (browser) where the qu