2,187
edits
Difference between revisions of "MS SQL"
Jump to navigation
Jump to search
m
→Commands and Maintenance: Added "Show database recovery modes"
(→Commands and Maintenance: Added "Table Sizes") |
m (→Commands and Maintenance: Added "Show database recovery modes") |
||
| Line 149: | Line 149: | ||
EXECUTE sp_who2; /* Show current processes */ | EXECUTE sp_who2; /* Show current processes */ | ||
SELECT name,log_reuse_wait_desc FROM sys.databases; /* Show why transaction log can't grow */ | SELECT name,log_reuse_wait_desc FROM sys.databases; /* Show why transaction log can't grow */ | ||
SELECT name,recovery_model_desc FROM sys.databases ORDER BY name /* Show database recovery modes */ | |||
</source> | </source> | ||