一、系统表数据字典的详细信息请查SQL SERVER BOL,这里仅列出一部分。1.1、sysservers1、查看所有本地服务器及链接服务器select * from master..sysservers1.2、sysdatabases1:查询非sa创建的所有数据库select * from master..sysdatabases where sid not in(select sid from master..syslogins where name='sa')--或者select dbid, name AS DB_NAME from master..sysdatabas Read More
posted @ 2011-04-14 17:05 Happy Hu Views(2872) Comments(0) Diggs(0) Edit