how to get the databases name in my server?
this is the only what i've got:
select database_name from information_schema.local :D
btw i'm using mssql2000
solution:there is sysdatabases in master table it gets all database_name of a certain local/server.
