Đang chuẩn bị liên kết để tải về tài liệu:
Microsoft SQL Server 2008 R2 Unleashed- P23

Microsoft SQL Server 2008 R2 Unleashed- P23:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major releases.Microsoft SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 174 CHAPTER 7 SQL Server System and Database Administration TABLE 7.2 SQL Server 2008 Alternatives for SQL Server 2000 System Tables SQL Server 2000 SQL Server 2008 System View View Type System Table sys.foreign_keys Catalog view syscurconfigs sys.configurations Catalog view sysdatabases sys.databases Catalog view sysdepends sys.sql_dependencies Catalog view sysdevices sys.backup_devices Catalog view sysfilegroups sys.filegroups Catalog view sysfiles sys.database_files Catalog view sysforeignkeys sys.foreign_keys Catalog view sysfulltextcatalogs sys.fulltext_catalogs Catalog view sysindexes sys.indexes Catalog view sys.partitions Catalog view sys.allocation_units Catalog view sys.dm_db_partition_stats DMV sysindexkeys sys.index_columns Catalog view syslanguages sys.syslanguages Compatibility view syslockinfo sys.dm_tran_locks DMV syslocks sys.dm_tran_locks DMV syslogins sys.sql_logins transact-sql Catalog view sysmembers sys.database_role_members Catalog view sysmessages sys.messages Catalog view sysobjects sys.objects Catalog view sysoledbusers sys.linked_logins Catalog view sysopentapes sys.dm_io_backup_tapes DMV sysperfinfo sys.dm_os_performance_counters DMV syspermissions sys.database_permissions Catalog view sys.server_permissions Catalog view sysprocesses sys.dm_exec_connections DMV Download from www.wowebook.com System Views 175 TABLE 7.2 SQL Server 2008 Alternatives for SQL Server 2000 System Tables SQL Server 2000 SQL Server 2008 System View System Table View Type sys.dm_exec_sessions DMV sys.dm_exec_requests DMV sysprotects sys.database_permissions Catalog view sys.server_permissions Catalog view sysreferences sys.foreign_keys Catalog view sysremotelogins sys.remote_logins Catalog view sysservers sys.servers Catalog view systypes sys.types Catalog view sysusers sys.database_principals Catalog view Catalog Views Using catalog views is the preferred method for returning information used by the Microsoft SQL Server database engine. There is a catalog view to