sql server 2005查看数据库schema, user 的存储过程

select * from sys.database_principals select * from sys.schemas select * from sys.server_principals

转载于:https://www.cnblogs.com/lfzwenzhu/archive/2010/05/25/1743594.html