Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Trace SQL queries

Author  Topic 

rischfre
Starting Member

15 Posts

Posted - 2011-12-06 : 15:54:07
Hi,

my company run a program which uses SQL Server 2008 R2. I would be interrested to trace all queries done. Unfortunately this program is compiled and there is no way to know it s logic.
Perhaps does exist a way, direcly in SQL Server to trace SQL queries executed during a laps of time.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-06 : 16:17:10
You can use SQL Profiler or a server-side trace to do this.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -