Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hawkeye75
Starting Member
5 Posts |
 Posted - 2008-01-22 : 16:34:57
|
| Originally I started using SQL Server Management Studio on the server directly. When I would right click on a view->edit I would essentially get a Alter Script of the view. Clicking on view-> design would open the query editor.However I decided to connect to the server from my desktop instead using a local installation of SQL Server Management Studio. Now when I right click on a view I only get the modify option which opens the Query Editor and not the actual code that can be scripted. I know I can just right click->script view as->alter to to get similar results. I just can't seem to find any options to change this functionality. Does anybody know how to change this or is this a limitation of a desktop installaion?Thanks |
|
|
Hawkeye75
Starting Member
5 Posts |
Posted - 2008-01-22 : 17:29:06
|
| I did some more digging and noticed that on the server install (which I didn't install) under Tools->Options there is an additional menu item called scripting which I do not have on my local install of the Studio. The options seem to be exactly what I'm looking for yet I can't seem to identify any additional plug-ins or tools that were installed. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-22 : 17:56:27
|
| do you maybe have ssms Express installed at home?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
Hawkeye75
Starting Member
5 Posts |
Posted - 2008-01-22 : 19:37:16
|
| No it's definitely not express. I'm going to to some searching tonight to see if I can track down what tool it might. It's nice because it also formats the scripts quite nicely. |
|
|
|
Hawkeye75
Starting Member
5 Posts |
Posted - 2008-01-22 : 19:53:18
|
| Figures...I found out that this option is not an add-in but actually part of SQL Server Management Studio.http://msdn2.microsoft.com/en-us/library/bb326600.aspxHowever, try to find any reason as to why it's nowhere to be found on my installation is another story. |
|
|
|
Hawkeye75
Starting Member
5 Posts |
Posted - 2008-01-22 : 19:59:33
|
| LOL...well It seems like I solved my own problems. For those interested this feature is available as part of SQL 2005 SP2.http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm |
|
|
|
|
|
|
Simple yet annoying! Management Studio Question