SQL Management Studio - setup

[kbear]

These are little things but I haven't seen them addressed elsewhere. Is there anyway to set your preferences in Mgmt Studio for these:
1. Opening a saved SQL query, not having it ask what to connect to.
2. Closing a query without it asking if you want to save it.
3. Not having everything open in a separate window such as open Job Activity monitor and then Job History - that's two new windows.

Thanks.

 

[Catadmin]

Answers in order:

1) Nope. Not that I've been able to figure out anyway.

2) Save it before you close it. If nothing's changed, then it won't ask you if you want to save it. (Yeah, I know. That's not the point of the question, but it's the only answer I have for you on this one.)

3) Nope. That's part of the new interface's ability to do multiple things at the same time. If it opened it in the same window (using the logic behind SQL 2000), then you'd only be able to mess with that one thing and have to close it before doing something else.

I personally like the multiple windows. Much more efficient, in my opinion, since I can compare the steps of 2 identical jobs on 2 different servers at the same time. @=)



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[kbear]

Thanks Catadmin. On #2, if I do a quick select statement, I don't want to save it (or sometimes multiple windows with queries in it). In SQL 2000, there was an option not to prompt to save. I have looked and looked,hoping that option is in Sql2005 also. I do like the tabbed windows in this version.

 

[Catadmin]

Nope. SQL Server 2005 was meant to be dummy-proof. @=)

Well, actually it was meant to be Developer-proof because Microsoft has all but admitted they didn't develop SSMS with the DBAs in mind. They did it solely for the Developer set who have a nasty tendancy to close windows without saving their code.

Now if you'll excuse me, I think I'll go hide from the developers. I like my scalp. @=)



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"