Way to view DB name in SQL Query Analyzer

[k108]

When I used to use Oracle, the only tool available at the time for running queries was - I can't even remember the name now. Sigh.

Anyhow, there was a way to set a configuration file so that every time you opened the tool (the name of which I can no longer remember), the cursor would show:

DATABASE NAME> "type your sql command here"

Which was really nice, because you knew EXACTLY which machine you were on and you wouldn't accidentally issue a statement to the wrong database.

Does SQL Query Analyzer have any such option?

Thanks

 

[amrita418]

AFAIK, there is no such option but can always db_name() to find out the database you are working on.

 

[amrita418]

But if you are using query analyzer it should have current database as one of the toolbar buttons right?

 

[k108]

Yeah, it shows on the top, I just like to see it in the cursor itself. More goofproof this way. Perhaps some of the non-gui tools allow this, but I don't use them.

With oracle, I set it up to show:

MACHINENAMEBNAME>

It was cool.

 

[amrita418]

Yea, I know you can define it in the login.sql or glogin.sql files.

I have been an oracle person myself for a long time but have enjoyed working with sql server too. The best part is that many limitations in sql server in comparison with oracle will cease with sql server 2005.