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 2008 Forums
 SQL Server Administration (2008)
 Tab description query analyzer

Author  Topic 

ZNJ
Starting Member

2 Posts

Posted - 2010-12-13 : 06:05:12
Hi,

I am looking for the following:
Having MSSMS version 10.0.2531.0

When I do a new query the screen appears with a tab.
In the tab there is a description like:

SQLQuery3.sql.......

Question:
Is it possible to change the way the description is build?
Like: name of the database and name of query.

Also when I reconnect to the sql server (the computer was hybernated) the tab shows: disconnected.

Question:
Is it possible to reconnect with the credentials used when the query was made? Not manual.

Thanks in advance,
John Zaagman

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-12-13 : 06:44:47
The name of the tab will eflect the filename for the query. If you save it as a file it will change.

If you lose a connection the query will give an error and reconnect automatically - so if you run again it should be connected.


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

ZNJ
Starting Member

2 Posts

Posted - 2010-12-13 : 10:42:39
Thanks Nigel,
Have tried and seen that. The cause of my question was that when I have unsaved queries I would like to customize the tab. Was searching in the setup but nothing.
When connection was lost and run again I have to walk through the Connect to server dialoque.
John
Go to Top of Page
   

- Advertisement -