return dartabase name

[muhannad]

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.

[DeadEyes]

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

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.

[Shuja Ali]

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

Select NAME From master..sysdatabases