[Catalyst]

If you're developing using SQL Server Express 2005 go grab this free Profiler:
http://sqlprofiler.googlepages.com/

What it does is opens a window where you can monitor everything going into SQL server. So if you've got dynamically created queries in you code or in a control it'll allow you to see what's actually getting sent to SQL Server. Great for debugging your SQL.

The Developer and above levels of SQL 2005 come with a profiler, so you really only need this if you're using the free Express version.

[Ben Abrams]

Catalyst, on Nov 19 2007, 07:15 AM, said:

So if you've got dynamically created queries in you code or in a control it'll allow you to see what's actually getting sent to SQL Server.

id hope all developers have got bug free / errors caught before this point, though

[Telos]

I would hope the SQL server profiler would allow to profile only one database at a time or then I just can't see where to select it. A bit annoying to start profiling when you have 50+ databases and all have constant activity

[mhack122]

Catalyst, on 19 November 2007 - 02:15 AM, said:

If you're developing using SQL Server Express 2005 go grab this free Profiler:
http://sqlprofiler.googlepages.com/

What it does is opens a window where you can monitor everything going into SQL server. So if you've got dynamically created queries in you code or in a control it'll allow you to see what's actually getting sent to SQL Server. Great for debugging your SQL.

The Developer and above levels of SQL 2005 come with a profiler, so you really only need this if you're using the free Express version.

thanks for the info ill use this software because im developing a system using VB.net 2010 and SQL Server 2008..SQL Server Profiler is a big help for me...

[EncoderDecoder]

SQL server profile..?