Database Status 1

[DBAWinnipeg]

Does anyone have a script that will return all "online" databases on a server?

What I mean by online is available for Read/writes, etc... not in read only mode, or single user, or dba only, etc

Just something that will return all available dbs.



Thanks in advance!!!

Colin in da 'Peg

 

[JamesLean]

Try this:

SELECT name,
	DATABASEPROPERTYEX(name, 'status') AS status,
	DATABASEPROPERTYEX(name, 'useraccess') AS user_access,
	DATABASEPROPERTYEX(name, 'isinstandby') AS standby
FROM master..sysdatabases
WHERE DATABASEPROPERTYEX(name, 'status') = 'online'
	AND DATABASEPROPERTYEX(name, 'useraccess') = 'multi_user'
	AND DATABASEPROPERTYEX(name, 'isinstandby') = 0
ORDER BY name

--James

 

[JayKusch]

Something like ...

select * from Master..sysdatabases

Thanks

J. Kusch

 

[DBAWinnipeg]

Thanks James