william的网络技术笔记

SELECT o.name as tablename,s.* FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) s,sys.objects o where o.object_id =s.object_id order by avg_fragment_size_in_pages desc

DECLARE B CURSOR FOR

1. REVOKE VIEW ANY DATABASE TO [public]   //取消PUBLIC查看所有数据库的权限