Is there a good way to understand the sysdatabases STATUS fields?

Question

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Reecha Mishra SSC Enthusiast Points: 177 More actions · Answer 1

Excellent information !!! thank you all, this helped me understanding the status value clearly.

randi3001 SSC Enthusiast Points: 124 More actions · Answer 2

try out this function

select name from sysdatabases

where name not in ('master','model','msdb','tempdb','pubs','Northwind')

and DATABASEPROPERTYEX(name,'status')='ONLINE'

i got it from Hall of Fame (Rudy Komacsar Senior Database Administrator)

for more information read the following thread

randi3001 SSC Enthusiast Points: 124 More actions · Answer 3

SSC Enthusiast

Points: 124

April 16, 2010 at 5:07 am

hi