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 2005 Forums
 Express Edition and Compact Edition (2005)
 How to trace sql requests

Author  Topic 

stu00
Starting Member

1 Post

Posted - 2006-04-05 : 11:39:03

Folks,

I have been hunting for a way to trace sql requests going to/from the sql express server (from VS.2005 using asp.net). I.E., I want to see the raw SQL commands that asp.net is generating.

Can anyone point me to a tool or article? Thanks,

--stuart

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2006-04-05 : 12:42:37
If you have access to a higher level Edition of SQL 2005, you can use SQL Profiler to do this. If you don't have a higher Edition, you can accomplish the same thing manually using SQL Trace. Search BOL for "SQL Trace" and you'll find several topics discussing it.

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Go to Top of Page
   

- Advertisement -