different SSMS2005 right-click menu options 1

[NuJoizey]

This is a silly little problem, and I think I have found the workaround, yet I'd just like to know the answer if someone out there has it.

On my development intallation of SSMS2005, i can right click any table, and my options are the familiar choices as follows:
New Table
Edit
Design
Open Table
Script Table As...

Yet, in both my test server and production environments the choices are a slight variance:

New Table
Modify
Open Table
Script Table As...

Design and Modify seem to give you the same screen, yet there is no equivalent in the test and production installations of the "edit" option.

The equivalent to Edit on my development machine seems to be To get there, it looks like you need to right-click, choose Script Table As.. and then CREATE TO > new query editor window.

I noticed that the installation version numbers are 9.00.3042.00 and 9.00.1399.00 respectively.

My questions are:
1. does the version account for the difference?
2. is there any simple way to get that handy little edit option into my other installations?

thank you for entertaining this question tek tips pros!

 

[mrdenny]

Yes, the version difference accounts for the difference. A lot of changes were made to the UI within the service packs. If you patch both systems to the same level you'll get the same options.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[NuJoizey]

great. thank you so much!

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog