return dartabase name

hi

im trying to find a function that returns the name of the database im using ..

for example, im using northwind in sql server. i want to return northwind, dbo and all databases on my local server (their names). shall i make several connections or just connecting to one is enough ! hope thats clear enough .. thnx much.

I don't have access to SQL Server at the moment but try

Code:

---

select name from sys.databases

---

that maybe version specific, there are usually views which do the same thing but are garunteed to be version independent.

If you have access to Master Database then you can use this query

PHP Code:

---

Select NAME From master..sysdatabases 


---