SQL Server Performance Forum – Threads Archive
No tools in SQL Server 2005
Hello, I installed MS Server 2005 workstation edition with every option availble to install and it’s been working fine, yet I cannot find any of the tools that are supposed to be installed. When I open Microsoft SQL Server Management Studio I go to the tools menu and there are only the following options available- "choose toolbox items… external tools… customise… options…" I have searched 100’s of tutorials on the net and they all say that to open SQL Profiler I just need to go to the tools menu and it should be there.I have tried reinstalling SQL server to make sure that I didn’t miss any options in the installation, yet that also didn’t work (still have no tools). I am using Windows XP SP2. Does anyone know how I could get profiler to work? I even tried searching the whole Server 2005 directory for any file starting with "profiler" yet it did not return any results. I really need to use profiler for a school assignment.
What version of 2005 do you have. Express or Workgroup?
Check:http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS†with no warranties for accuracy.
SQL Server 2005 Workgroup Edition
As per BOL
quote:
SQL Server 2005 Workgroup Edition is the data management solution for small organizations that need a database with no limits on size or number of users. SQL Server 2005 Workgroup Edition can serve as a front-end Web server, or for departmental or branch office operations. It includes the core database features of the SQL Server product line, and is easily upgradeable to SQL Server 2005 Standard Edition or SQL Server 2005 Enterprise Edition. SQL Server 2005 Workgroup Edition is an ideal entry-level database that is reliable, robust, and easy-to-manage.
SQL Server 2005 Workgroup Edition is the data management solution for small organizations that need a database with no limits on size or number of users. SQL Server 2005 Workgroup Edition can serve as a front-end Web server, or for departmental or branch office operations. It includes the core database features of the SQL Server product line, and is easily upgradeable to SQL Server 2005 Standard Edition or SQL Server 2005 Enterprise Edition. SQL Server 2005 Workgroup Edition is an ideal entry-level database that is reliable, robust, and easy-to-manage.
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Ok thanks, guess the workgroup edition doesn’t have the tools I need, going to upgrade to the enterprise edition. Thanks for your help
For testing purpose you don’t need to have Enterprise Edition, you can use Develper edition which will have all tools and features in Ent. Edition. Mohammed U.
Even for test purpose for a limited time, Evaluation Enterprise Edition is suitable too. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
standard edition has profiler too I believe. SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003
www.elsasoft.org
]]>