Microsoft SQL 2008 profiler

I have a development installation with SQL express 2008 R2. Obviously the profile is not there.

Not to mention the fact that the handsome anjlab sql profiler, it is no longer free.

Then. So glad I found these directions

I have a development installation with SQL Express 2008 R2. Obviously, the profiler does not exist.

Not to mention the fact that the beautiful anjlab sql profiler, is no longer free.

I know. Luckily I found this information:

(http://blog.tonysneed.com/2010/08/05/setting-up-sql-server-2008-express-with-profiler/).

In short, you should download the evaluation version of SQL Server 2008 R2:

Trial Edition: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=de21dffd-4c6c-4963-b00c-5153cf7e41dd

Then unpack and run the command:

setup.exe/Q/INDICATEPROGRESS/INSTANCENAME/FEATURES/ACTION = Install = Tools/BROWSERSVCSTARTUPTYPE = MSSQLSERVER/AGTSVCACCOUNT = "NT AUTHORITYNETWORK SERVICE" = Automatic/IACCEPTSQLSERVERLICENSETERMS

Remember that/INSTANCENAME = MSSQLSERVER must be updated to the name of your instance (sqlexpress for example).

Wait, even quite a while. It's all. Now the profiler appears in the tool menu of your SQL Management studio.

Whew!

(http://blog.tonysneed.com/2010/08/05/setting-up-sql-server-2008-express-with-profiler/).

In summary, you must download the trial edition of SQL Server 2008 R2:

Trial Edition: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=de21dffd-4c6c-4963-b00c-5153cf7e41dd

The unpacking and run the command:

setup.exe/Q/INDICATEPROGRESS/INSTANCENAME/FEATURES/ACTION = Install = Tools/BROWSERSVCSTARTUPTYPE = MSSQLSERVER/AGTSVCACCOUNT = "NT AUTHORITYNETWORK SERVICE" = Automatic/IACCEPTSQLSERVERLICENSETERMS

Just remember that/INSTANCENAME = MSSQLSERVER should be updated with the name of your instance (sqlexpress).

Wait, even quite a bit. It's all.  Now the profile appears in the menu Tools of your management studio of SQL.

Thank goodness!

Leave a Reply

Your email address will not be published. Required fields are marked *

For Inspirations, Special Offers and Much More

Address

Via Scoglio grosso 28
05100 Terni, Italy
+39 3388383150
venturini@ict360.it

cf: VNTFNC73P11L117N
p.iva: 00723880555

©Francesco Venturini. All Rights Reserved