What is this query for?

Hi,

Yes it will return all the database names as well as other information of the database like dbid, sid, filename, version etc.
It is used to getting information of all those databases which are created in sql server except system databases.

Hi Nethra,

select * from sysdatabases where sid <> 0x01 order by name This gives all non system databases informations like name,Filename,version ,status... etc. Thanks.

Hi,

Suppose i have some 50 databases.. Will it return all the database names? Why is it used and where? In what situations?

Hi, Nethra R S
           
                    this query is used To get the database names.

Hi,

Does it give all the database names?