SQL Server - Current Database

Is there anyway, using ADO (2.6) or T-SQL (SQL Server 2000) to find out the current database when you are connected?

Quote:

---

Originally Posted by simonm

Is there anyway, using ADO (2.6) or T-SQL (SQL Server 2000) to find out the current database when you are connected?

---

Isn't it sitting in text in the CONNECTION STRING? Didn't you build the connection string in code?

Quote:

---

Originally Posted by szlamany

Isn't it sitting in text in the CONNECTION STRING? Didn't you build the connection string in code?

---

For the particular application I am building, the user can select which database he wishes to use. However, when connecting to a server, each login may have a default database.

I simply need to be able to query the connection to find out what my current database context is...

Use the db_name() function:

Code:

---

Select db_name()

---

That will return the name of the current database.

Thanks vb_dba!