|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Trying to get Mgmt Studio to work as expectedWhen 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. 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..... Thanks! Marc Marc Scheuner (marc.NOSPAM.scheuner@gar-NOREPLY-aio.com) writes:
> When I launch SQL Server 2005's Management Studio from the command line, I would like that too! But I never found it irritating enough to > 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. 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 Now, this is one I have bitched severly about! Without reward.> 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..... 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, esq***@sommarskog.se 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 >I would like that too! But I never found it irritating enough to Care to open a request for that? ;-) (I'm sure it carries more weight>bitch about it during the beta prorgamme. >You can right-click in the query window and select "Open in Object Browser". when it comes from a SQL Server MVP, rather than a newbie) >> Also, is there any way (documented in the UI or undocumented by means of a Done. Let's hope SQL Server 2005 SP2 will include those fixes !! >> 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. >http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=b28b4a47-fb76-42aa-a882-94b9ba891b14 >that you can vote for. Thanks, Erland. Marc Marc Scheuner (no.spam@for.me) writes:
>>I would like that too! But I never found it irritating enough to Nah, you do it! The tools team probably moan every time they hear>>bitch about it during the beta prorgamme. >>You can right-click in the query window and select "Open in Object >>Browser". > > Care to open a request for that? ;-) (I'm sure it carries more weight > when it comes from a SQL Server MVP, rather than a newbie) my name by now! And for me it is just a mild irritation. >>Now, this is one I have bitched severly about! Without reward. Alas, there is no indication that "no prompt on exit" is going to>>http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid >>=b28b4a47-fb76-42aa-a882-94b9ba891b14 >>that you can vote for. > > Done. Let's hope SQL Server 2005 SP2 will include those fixes !! materialise. The problem is that it is a very odd behaviour for an editor. But it was just right in QA, because QA is not an editor for me. I use QA for ad hoc queries. Editing code I do from Textpad. Overall, it appears that MS forgot about the DBAs when they brought in Visual Studio. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se 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 Marc Scheuner (no.spam@for.me) writes:
>>I would like that too! But I never found it irritating enough to I found that there already is a request for this:>>bitch about it during the beta prorgamme. >>You can right-click in the query window and select "Open in Object >>Browser". > > Care to open a request for that? ;-) (I'm sure it carries more weight > when it comes from a SQL Server MVP, rather than a newbie) http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=2acc2513-29a8-4374-9704-30c25225e6f7 Just go ahead and vote! -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se 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 >I found that there already is a request for this: Ah, excellent - my vote was added ! >http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=2acc2513-29a8-4374-9704-30c25225e6f7 Let's hope we'll see this *BEFORE* SQL Server 2010 :-( Marc  |
|||||||||||||||||||||||
Other interesting topics