Re: Trying to get Mgmt Studio to work as expected

Marc Scheuner (marc.NOSPAM.scheuner@xxxxxxxxxxxxxxxxxxx) writes:
When I launch SQL Server 2005's Management Studio from the command line,
specifying server and database I want to work with, I find it extremely
irritating that the Object Browser doesn't also connect to that server
using the credentials supplied. If I want to go see stuff on the server,
I have to AGAIN establish a connection separately - very annoying and
irritating.

Any way to make this work automatically?? E.g. if I launch sqlwb.exe with
"-S (local) -E -d MyDatabase", I'd like to make sure Object Browser ALSO
connects to my local server and selects the "MyDatabase" as its active
database.

I would like that too! But I never found it irritating enough to
bitch about it during the beta prorgamme.

You can right-click in the query window and select "Open in Object Browser".

Also, is there any way (documented in the UI or undocumented by means of a
registry hack) to turn OFF these pesky "do you want to save this query?"
messages that tend to pop up all over the place??? QueryAnalyzer had an
option to do so.....

Now, this is one I have bitched severly about! Without reward.

I have a suggestion on
http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=b28b4a47-fb76-42aa-a882-94b9ba891b14
that you can vote for.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Dynamic DNS management
    ... I'm in the process of setting up a web server - actually, it's pretty much working, just a few irritating things lurking about, occasionally leaping out and biting me on the arse. ... One of the irritations is that with a dynamic DNS, I'm having to update the IP addresses for the authoritative DNS server of multiple domains hosted here. ... I wrote a little Perl script to check the IP and log it and compare with last time it checked, and do the update only if the two don't match. ...
    (comp.lang.perl.misc)
  • Re: Ximian Evolution on Solaris 9 Sparc (installed but aborts)
    ... > mobile version of it with solaris, somewhat irritating. ... server. ...
    (comp.unix.solaris)
  • Trying to get Mgmt Studio to work as expected
    ... When I launch SQL Server 2005's Management Studio from the command line, ... specifying server and database I want to work with, ... AGAIN establish a connection separately - very annoying and irritating. ...
    (microsoft.public.sqlserver.tools)
  • Re: Apache2 and PDF download problems
    ... On Wed, 12 Oct 2005, Sean Davis wrote: ... > I have a set of PDF's on my server ... Top-posting. ... What's the most irritating thing on Usenet? ...
    (comp.infosystems.www.servers.unix)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)