As far as I can tell, we've got SQL server 2008 installed, however no one's updated the client tools since 2000. I need to install the NON-Express version of Management Studio so I can apply the Database Engine Tuning Advisor to some tables and queries for index optimization.
The difficulty is that the install disks are in another office and and it's difficult to get that guy to cooperate (he and I are both very busy.) Is there somewhere I can download the NON-Express version?
It's my understanding that the Express version doesn't have the analysis tools that the NON-Express version does. If I'm incorrect about that then please someone tell me how to use this Express version to optimize an index 'cause I've been messing around with it and I can't figure it out.
Here's the information from our SQL instance which I believe is 2008:
Edition: Enterprise Edition
EngineEdition: 3 = Enterprise