sql-server-profiler
Debugging "Incorrect Syntax" Exception
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.[详细]
2022-12-30 05:14 分类:问答In SQL Server, how to move/import a multiple .trc files to a trace table
I have a set of rollover .trc files recorded with Sql Profiler. mytrace.trc mytrace_1.trc mytrace_2.trc mytrace_3.trc[详细]
2022-12-29 23:44 分类:问答Is there a way in SQL profiler to filter by INSERT statements?
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[详细]
2022-12-22 19:35 分类:问答What is "Audit Logout" in SQL Server Profiler?
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开[详细]
2022-12-17 06:22 分类:问答Can SQL Profiler display return result sets alongside the query?
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?[详细]
2022-12-16 22:30 分类:问答SQL Server Profiler: How can I display query parameter values in deadlock graph?
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[详细]
2022-12-14 13:41 分类:问答Find user by PID in Citrix environment
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[详细]
2022-12-13 09:56 分类:问答How can i see what IP address made the request to SQL Server?
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[详细]
2022-12-10 01:14 分类:问答