views:

734

answers:

5

Hi,

Is it possible to get sql profiler for sql2008 for free or you have to have a license to get it?

i.e. it won't work with sql express

+3  A: 

First. SQL Profiler does work with SQL Express. Second. You can get SQL Profiler with the Developer version of SQL, which is included with all MSDN licenses. However you will not be able to get it for free with SQL Express like you can with SSMS.

Nick Berardi
ok so I just get the MSDN sql2008 disk and it will be a addon?
Blankman
A: 

SQL Express 2008 Management Studio does not come with Profiler, so you will have to get a license for either a Workgroup/Standard/Enterprise edition.

Mitch Wheat
Don't forget about Developer which is basically Enterprise but at a much cheaper license rate.
Nick Berardi
Thanks @Nick, I did mean to mention Developer version. Thanks for pointing it out.
Mitch Wheat
A: 

SQL Server 2008 Developer Edition isn't free, but it's about $50 at NewEgg (or anywhere else):

Newegg.com product link

Developer edition is basically a re-branded not-for-production version of Enterprise, so it's got all the features Enterprise has, including Profiler. That's as close to free as you're going to get, since Profiler is not included with any Express products.

rwmnau
+2  A: 

SQL Profiler is just a GUI on top of the TRACE functionality present in all editions of SQL.

http://sqlprofiler.googlepages.com/ is a free utility which takes advantage of that. Probably all that you need.

JohnW
A: 

Dear sir,

how do use profiler in sql2008, plz reply must

thanks lokesh

lokesh