Computing.Net > Forums > Database > know the name of the database

know the name of the database

Reply to Message Icon

Original Message
Name: trichyselva
Date: April 10, 2006 at 06:00:34 Pacific
Subject: know the name of the database
OS: windows xp
CPU/Ram: p4
Model/Manufacturer: pentium
Comment:

what is the sql query to find out to which database we are connected


Report Offensive Message For Removal


Response Number 1
Name: babaji
Date: April 15, 2006 at 10:47:54 Pacific
Reply: (edit)

Try this

select @@db_name

I am not sure b’cos I have no sql server right now


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: know the name of the database 

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software




Have you ever used OpenOffice?

Yes, as my main suite.
Yes, occationally.
Yes, but only once.
No, never.


View Results

Poll Finishes In 4 Days.
Discuss in The Lounge