Tag: SQL

Microsoft SQL 2008 profiler

Ho una installazione di sviluppo con SQL express 2008 R2. Ovviamente il profile non c’è.

Per non parlare del fatto che il bel anjlab sql profiler, non è più free.

Quindi. Per fortuna ho trovato queste indicazioni

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.

So. 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 /FEATURES=Tools /Q /INDICATEPROGRESS /ACTION=Install /INSTANCENAME=MSSQLSERVER /BROWSERSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT=”NT AUTHORITY\NETWORK SERVICE” /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 managment studio.

Whew!

Continua a leggere

For Inspirations, Special Offers and Much More

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

cf: VNTFNC73P11L117N
p.iva: 00723880555

© 2018 Francesco Venturini. All Rights Reserved