Sql server 2008 edition information:
SELECT SERVERPROPERTY('Edition');
SELECT SERVERPROPERTY('EngineEdition');
SELECT SERVERPROPERTY('EngineEdition');
USE master;
SELECT name FROM sys.objects
WHERE type_desc = 'SYSTEM_TABLE';
SELECT name FROM sys.objects
WHERE type_desc = 'SYSTEM_TABLE';
dedicated administrator connection (DAC),
there are three types of system metadata objects:
Dynamic Management Objects
The other two types of system objects are actually views built on top of the system base tables.
Compatibity views :
sysobjects, sysindexes, sysusers, and sysdatabases. Others, like sysmembers and sysmessages,
pseudotables, such as sysprocesses and syscacheobjects.
you must access three Dynamic Management
Objects: sys.dm_exec_connections, sys.dm_exec_sessions, and sys.dm_exec_requests.
Objects: sys.dm_exec_connections, sys.dm_exec_sessions, and sys.dm_exec_requests.
Catalog Views
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/445851/viewspace-667050/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/445851/viewspace-667050/