Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SSMS Trama (yes, this is really bugging me) Expand / Collapse
Author
Message
Posted Friday, July 1, 2011 11:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, December 19, 2014 8:46 AM
Points: 5,676, Visits: 6,488
In Tools -> Options -> General, I have "At Startup" set to Open Empty Environment. This works wonderfully with 2k5, as it has no summary window and I have to go into Object Explorer to open my databases. Also, it forces me to choose which environment to open new queries in each time.

Unfortunately, SQL 2k8 isn't working that way. I get a blank Object Explorer Details screen (I don't want this to show up unless I call it) and it auto-opens queries to the last used query screen (which I REALLY don't want, especially if I had a production window open as the last query screen).

Does anyone know what I need to do in order to force it to do my expected behavior? I really don't want to inadvertently run Dev code in a Prod connection. That Would Be Bad.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1135265
Posted Friday, July 1, 2011 12:34 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:58 AM
Points: 13,872, Visits: 9,600
I can't get it to do precisely what you're describing.

I do get the empty Object Explorer, but I don't get any scripts/connections re-opening. Am I misunderstanding what you mean about queries re-opening?

Have you tried setting the Auto Hide option on Object Explorer? Does that give you what you want?


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1135298
Posted Tuesday, July 5, 2011 5:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, December 19, 2014 8:46 AM
Points: 5,676, Visits: 6,488
Gus,

The first time I open up a script, SSMS will ask me to pick a server connection. But each time after that, it will not. It will auto-connect to the server that I last opened a connection to. I don't want it to auto-connect. I want to force SSMS to ask me each time I open a script which server to use.

Does that make sense?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1136368
Posted Tuesday, July 5, 2011 6:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:58 AM
Points: 13,872, Visits: 9,600
Ah! I get it now.

No, there doesn't appear to be an option for that. The closest would be under Query Execution options, "Disconnect after the query executes".


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1136420
Posted Tuesday, July 5, 2011 6:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, December 19, 2014 8:46 AM
Points: 5,676, Visits: 6,488
GSquared (7/5/2011)
No, there doesn't appear to be an option for that. The closest would be under Query Execution options, "Disconnect after the query executes".


Which isn't what I want.

Darnit.

Thanks for double-checking.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1136423
Posted Tuesday, July 5, 2011 9:22 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:19 AM
Points: 149, Visits: 1,031
Brandie Tarvin (7/5/2011)
GSquared (7/5/2011)
No, there doesn't appear to be an option for that. The closest would be under Query Execution options, "Disconnect after the query executes".


Which isn't what I want.

Darnit.

Thanks for double-checking.

Brandie,

In the File menu in SSMS 2008 R2 there is an option under Open -> File with New Connection and File Disconnected.

Granted, this does not allow you to double-click to open a file and then login or drag and drop, but it is an option. Unfortunately, there is not a shortcut for this one, but I think that it could be added to the toolbar.



Regards,

Irish
Post #1136569
Posted Tuesday, July 5, 2011 10:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, December 19, 2014 8:46 AM
Points: 5,676, Visits: 6,488
Jeffrey Irish (7/5/2011)
In the File menu in SSMS 2008 R2 there is an option under Open -> File with New Connection and File Disconnected.


I've got regular 2k8 at work, not R2.

Thanks, anyway.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1136631
Posted Tuesday, July 5, 2011 12:20 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 1,503, Visits: 2,819
The first time I open up a script, SSMS will ask me to pick a server connection. But each time after that, it will not. It will auto-connect to the server that I last opened a connection to. I don't want it to auto-connect. I want to force SSMS to ask me each time I open a script which server to use.


Seems like odd behavior but when I open a new query using "Database Engine Query" instead of "New Query" all subsequent .sql file I open ask for database connection until I restart SSMS.


Bob
-----------------------------------------------------------------------------
How to post to get the best help
Post #1136744
Posted Tuesday, July 5, 2011 12:26 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, December 19, 2014 8:46 AM
Points: 5,676, Visits: 6,488
Bob,

Aha. That does work for new queries. Thanks.

I'm still trying to figure out a way to open up my saved queries, though, without having SSMS auto-connect them. Any thoughts?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1136747
Posted Tuesday, July 5, 2011 12:37 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 1,503, Visits: 2,819
not quite sure what you mean by "saved queries".

Bob
-----------------------------------------------------------------------------
How to post to get the best help
Post #1136752
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse