new (to me) behavious in management studio editor

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.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

new (to me) behavious in management studio editor

Author

Topic

chedderslam
Posting Yak Master

223 Posts

Posted - 2008-10-09 : 17:23:43

I have never seen this before, and I'm hoping that someone can tell me how to turn it off and on and when this feature became avaialble.

I just installed SQL Server SP2 through windows update today, but that may be a coincidence, as I have installed the sp on other machines in the past and didn't see this.

If I open a new query window and type in a statement like below:

SELECT *
FROM TABLE

then click on verify syntax or execute, the query modifies itself to show the columns like below:

SELECT COLUMN1, COLUMN2, COLUMN3
FROM TABLE

How is this happening?

Thank you.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-09 : 17:45:06

That didn't happen as a result of service pack 2. You must've installed a third-party add-on that is doing this for you.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

chedderslam
Posting Yak Master

223 Posts

Posted - 2008-10-09 : 17:54:42

Is there any way to check which add-ons are installed?

Also, the options on the tool bar are different. It has the buttons:
show diagram pane, show criteria pane, show sql pane, show results pane.

Also, I am unable to save the query(the option is greyed out).

I assume I am in a different mode, I just don't know what it is called or how I got there....

Thanks.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-10-09 : 18:04:05

does the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell\AddIns
registry key have any subkeys?

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!

chedderslam
Posting Yak Master

223 Posts

Posted - 2008-10-10 : 10:14:02

quote:
Originally posted by spirit1

does the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell\AddIns

The addins key does not exist under shell.

I found that Embarcadero DBArtisan 8.1.2 is installed, could that be it? It seems to be more of a stand alone thing, so I don't see how it would change management studio...

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-10-10 : 10:30:32

ok then you don't have any direct add-ins installed.

as i see the Embarcadero DBArtisan 8.1.2 is a stand alone product. it shouldn't have any impact on ssms.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!

chedderslam
Posting Yak Master

223 Posts

Posted - 2008-10-10 : 10:36:22

Could this just be a feature of ssms that I am not aware of?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-10-10 : 10:37:34

if it is i've never seen it. could you post a picture of it?

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!

chedderslam
Posting Yak Master

223 Posts

Posted - 2008-10-10 : 11:19:57

quote:
Originally posted by spirit1

if it is i've never seen it. could you post a picture of it?

I am playing with it now, and it is just right clicking on the table in object explorer and selecting open table, then clicking the show sql pane button.

here's a screen grab:

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-10-10 : 11:40:47

ahhh... this is the sql pane of the modify table you're talking about. it's not meant as a true query window.
i've just tried running/verifying a query and it doesn't expand my * to column list.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!

chedderslam
Posting Yak Master

223 Posts

Posted - 2008-10-10 : 11:58:16

Under options > text editor it has "DMX Query Editor".

Does this mean anything?

Under options > text editor > all languages it has, nder statement completion: Auto list members(checked)

Mabye that?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-10-10 : 12:17:06

i have the same settings... still not happening.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources