Study the sql server 2008 internals

Sql server 2008 edition information:

 

SELECT SERVERPROPERTY('Edition');
SELECT SERVERPROPERTY('EngineEdition');

 

USE master;
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.

 

Catalog Views

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/445851/viewspace-667050/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/445851/viewspace-667050/