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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-01-10 : 12:39:59
|
| Which system table is this information held in, i restored over 100 databases and want all of them to be simple mode.I manually set it each time after each restore, but i want to confirm but i cannot find the sys table to do a select on.I looked at sys.sysdatabases |
|
|
MuadDBA
628 Posts |
Posted - 2008-01-10 : 12:43:51
|
| Did you try any of the DMVs? |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-10 : 12:49:28
|
| Did not see dmv that gave me the mode of database |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
|
|
|
|
|
Simple Full Mode