SQLSEVER系统数据库表

master

select * from MSreplication_options

select * from spt_fallback_db

select * from spt_fallback_dev

select * from spt_fallback_usg

select * from spt_monitor

select * from spt_values


msdb

select * from DTA_input
select * from DTA_output
select * from DTA_reports_column
select * from DTA_reports_database
select * from DTA_reports_index
select * from DTA_reports_indexcolumn
select * from DTA_reports_partitionfunction
select * from DTA_reports_partitionscheme
select * from DTA_reports_query
select * from DTA_reports_querycolumn
select * from DTA_reports_querydatabase
select * from DTA_reports_queryindex
select * from DTA_reports_querytable
select * from DTA_reports_table
select * from DTA_reports_tableview
SELECT * FROM DTA_tuninglog

tenpdb

SELECT * FROM MSdistributor_access


posted @ 2011-12-04 12:11  wala-wo  阅读(255)  评论(0编辑  收藏  举报