.NET/SQL viewer

[TheSteph]

Does anybody know a tool that I could use to see all SQL statements send
by my application (C# .NET 2.0 ) to SQL Server ?

I know Delphi has that kind of tool.

Thanks

Steph.

[Fao, Sean]

TheSteph wrote:

Does anybody know a tool that I could use to see all SQL statements send
by my application (C# .NET 2.0 ) to SQL Server ?

I'm not too familiar with SQL 2005, but 2000 has a utility called
"Profiler", which lets you do just that. It works similarly to a packet
sniffer.

Hope that helps,

--
Sean

[Douglas Richard]

TheSteph wrote:

Does anybody know a tool that I could use to see all SQL statements send
by my application (C# .NET 2.0 ) to SQL Server ?

I know Delphi has that kind of tool.

Thanks

Steph.

SQL Server 2000 shipped with SQL Profiler, which I use to monitor the
statements sent by my program. I would assume that SQL Server 2005 has
something similar?

[Siva M]

SQL Server 2005 (Std & Enterprise editions only) also has Profiler.

"TheSteph" <Th******@NoSpam.comwrote in message
news:Oo**************@TK2MSFTNGP03.phx.gbl...
Does anybody know a tool that I could use to see all SQL statements send
by my application (C# .NET 2.0 ) to SQL Server ?

I know Delphi has that kind of tool.

Thanks

Steph.

[Andrew Petrochuk [MSFT]]

Monitoring with SQL Profiler
http://msdn.microsoft.com/library/de..._perf_86ib.asp

Introduction to SQL Profiler
http://www.developer.com/db/article.php/3482216
--

This posting is provided "AS IS" with no warranties, and confers no rights.
"TheSteph" <Th******@NoSpam.comwrote in message
news:Oo**************@TK2MSFTNGP03.phx.gbl...

Does anybody know a tool that I could use to see all SQL statements send
by my application (C# .NET 2.0 ) to SQL Server ?

I know Delphi has that kind of tool.

Thanks

Steph.