SQL Trace 1

[hramos25]

Dear Sir Or Madam,

I have a problem with a Microsoft application when user enters a batch hit save the batch the application just run and run, never returns. I would like to run a SQL Profile Trace just for that specific process so I can see what is doing.. can some please tell me what steps I need to take to run a trace that only give the results when user is trying to process the batch... DO I need to synchronize and start the trace then process the batch..

Thanks in advance for your help

James

 

[mrdenny]

Fire up SQL PRofiler, and filter it based on the hostname of the person running the software that is having the problem. This will capture all the commands that they execute against the SQL Server.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog