Difference between revisions of "MS SQL"
Jump to navigation
Jump to search
(Added "Manual Backup") |
m (→Commands and Maintenance: added execute sp_who2;) |
||
| Line 143: | Line 143: | ||
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%' /* Show tables */ | SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%' /* Show tables */ | ||
SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' /* Show base tables only (not views etc) */ | SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' /* Show base tables only (not views etc) */ | ||
EXECUTE sp_who2; /* Show current stored procedure status' */ | |||
</source> | </source> | ||