ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Study the sql server 2008 internals

Study the sql server 2008 internals

原创 Linux操作系统 作者:alexzhou618 时间:2010-07-02 22:29:35 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-04-22

  • 博文量
    52
  • 访问量
    37431