Friday, February 26, 2010

All Database name in DB Server


To gat all Database name in DB Server

SELECT * FROM master.dbo.sysdatabases

WHERE name NOT IN ('master','model','msdb','tempdb')

No comments:

Post a Comment