Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Norwich
Posting Yak Master
158 Posts |
 Posted - 2006-06-20 : 04:19:49
|
| HiQuick Question:Is there anyway that I can check when a database last changed it's status?example: From Suspect to OnlineRegardsNThe revolution won't be televised! |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-20 : 17:23:11
|
| Is it in the SQL (Error) Log?Kristen |
 |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-06-21 : 02:17:49
|
| I was hoping that it was stored in a table somewhere in the master db but I guess the error log will do.ThanksRegardsNThe revolution won't be televised! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-21 : 09:07:23
|
| SQL2005 I believe you could put a trigger-type-thingie (i.e. on a system table) to allow you to record that, but not in SQL 2000 that I know of.You could have scheduled job compare the sysdatabases table every, say, minuet against a copy stored in your own table and "audit" and changes that are relevant to you.Kristen |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-06-21 : 09:40:59
|
quote:
Originally posted by Kristen
SQL2005 I believe you could put a trigger-type-thingie (i.e. on a system table) to allow you to record that, but not in SQL 2000 that I know of.
Ah yes, trigger-type-thingy's ....  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-21 : 09:46:37
|
| I knew you'd know what knew not |
|
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-06-22 : 01:46:22
|
| Good Idea!I think the trigger-type-thingie will do the jobRegardsNThe revolution won't be televised! |
|
|
|
|
|
|
State Change Date