Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I just upgrade from SQL Server 2008 Express with advance services to Dev Edition. I wonder whether SQL Profiler is available for the Dev Edition?

Please let me know how to access that if it is present.

share|improve this question

2 Answers 2

You may need to uninstall Management Studio Express in order to have the option to install Management Tools from Dev edition. Pretty sure they can't co-exist and Management Tools might be greyed out in the installer if SSMSE is already present.

share|improve this answer

Yes, it is available in the installer for development edition. Without firing it up, I'm not sure if the installer has changed between 2008 and 2008R2 but in 2008 there are two options for installing client tools.

  • Management Tools (Basic) which installs SSMS, SQLCMD and Powershell support
  • Management Tools (Complete) adds Profiler, Database Tuning Advisor, Integration Services, Reporting Services.
share|improve this answer
    
Thanks but i can't see. How to go for Complete Management tools? –  Romil N Feb 13 '12 at 11:08
    
From the installer (setup.exe). –  Mark Storey-Smith Feb 13 '12 at 11:12
    
As i said, i have upgrade from Express to Dev. This option was not present in Dev edition. –  Romil N Feb 13 '12 at 11:16
5  
So how did you do the upgrade? Wasn't it starting from a kit of the Development edition? Dev edition is the same as Enterprise, contains all features. They just need to be installed/enabled. –  Marian Feb 13 '12 at 11:25
1  
+1 on comparing 'Basic' versus 'Complete' install of Management Tools. –  OliverAsmus Feb 13 '12 at 19:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.