March 2, 2009 at 12:47 pm
I was putting together a simple monitoring script this morning when I ran into something unexpected. I was querying the sysdatabases table to get the current status of the production db's. When I used the DATABASEPROPERTYEX() function to translate the "Status" column for me, I had a NULL status for a handful of production db's. This seemed very odd in that the actual numeric status was the same as some of the other prod db's that translated successfully. Has anybody else ran into this issue before? And if so, how did you fix it?
Thanks
JT
I compare being a DBA to that of Smokey The Bear. Helping to prevent wildfires in your forest of servers and applications.
March 2, 2009 at 12:50 pm
Can you provide the code you were working with?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply