新的和已更新的联机丛书主题(2005 年 12 月 5 日)
新建日期: 2005 年 12 月 5 日
2005 年 12 月 5 日 版本的 SQL Server 联机丛书添加了新主题,或在以下技术或类别中更新了现有主题。
主题列表
ADOMD.NET |
Integration Services 编程 |
示例 |
分析管理对象 (AMO) |
国际化注意事项 |
SQL Server 管理对象 (SMO) |
Analysis Services |
Notification Services 编程 |
工具和实用工具 |
数据库引擎 |
复制 |
Transact-SQL |
全文搜索 |
复制编程 |
教程 |
安装 |
Reporting Services |
用户界面参考 |
Integration Services |
Reporting Services 编程 |
配置管理的 WMI 提供程序 |
ADOMD.NET
新主题
ADOMD.NET Client FunctionalityADOMD.NET Client Object Architecture
ADOMD.NET Server Functionality
ADOMD.NET Server Object Architecture
Analysis Management Objects (AMO)
Establishing Secure Connections in ADOMD.NET
Executing Commands Against an Analytical Data Source
Performing Transactions in ADOMD.NET
Retrieving Data from an Analytical Data Source
Retrieving Data Using the AdomdDataReader
Retrieving Data Using the CellSet
Retrieving Data Using the XmlReader
Retrieving Metadata from an Analytical Data Source
User Defined Functions and Stored Procedures
Working With Connections and Sessions in ADOMD.NET
返回页首
分析管理对象 (AMO)
-
Analysis Management Objects (AMO)
Programming Administrative Tasks with AMO
Programming AMO Complementary Classes and Methods
Programming AMO Data Mining Objects
Programming AMO Fundamental Objects
Programming AMO OLAP Advanced Objects
返回页首
Analysis Services
返回页首
数据库引擎
新主题
关于缺失索引功能如何为 SQL Server 更改服务启动帐户(SQL Server 配置管理器)
如何创建存储过程 (SQL Server Management Studio)
如何删除存储过程 (SQL Server Management Studio)
如何授予对存储过程的权限 (SQL Server Management Studio)
如何修改存储过程 (SQL Server Management Studio)
如何重命名数据库 (SQL Server Management Studio)
如何重命名存储过程 (SQL Server Management Studio)
如何重新启动 SQL Server Agent 服务 (SQL Server Management Studio)
如何将数据库设置为单用户模式 (SQL Server Management Studio)
如何查看存储过程的定义 (SQL Server Management Studio)
更新的主题
还原顺序的高级注意事项Audit Database Object Access 事件类
Audit Database Object Take Ownership 事件类
Audit Database Principal Impersonation 事件类
Audit Schema Object Access 事件类
Audit Schema Object Take Ownership 事件类
Audit Server Object Take Ownership 事件类
Audit Server Principal Impersonation 事件类
Audit Statement Permission 事件类
如何配置 SQL Server 代理邮件以使用 SQL Mail (SQL Server Management Studio)
如何创建主 SQL Server 代理作业 (Transact-SQL)
如何分离数据库 (SQL Server Management Studio)
如何启用数据库引擎的加密连接(SQL Server 配置管理器)
如何在主服务器上登记目标服务器 (SQL Server Management Studio)
如何还原差异数据库备份 (SQL Server Management Studio)
如何还原事务日志备份 (SQL Server Management Studio)
如何为 SQL Server 代理设置服务启动帐户(SQL Server 配置管理器)
如何设置数据库关系图设计器 (Visual Database Tools)
如何启动作业 (SQL Server Management Studio)
如何使用分离和附加来升级数据库 (Transact-SQL)
使用 SQL Server Profiler 创建和测试计划指南
返回页首
全文搜索
- 新主题
配置同义词库文件
返回页首
安装
新主题
设置 DTS 应用程序属性如何排除 SQL Server 2000 和 SQL Server 2005 Reporting Services 的并行安装故障
更新的主题
使用包迁移向导SQL Server 2005 Reporting Services 中不推荐使用的功能
如何在 64 位计算机上安装 32 位 Reporting Services
使用安装程序安装 SQL Server Analysis Services
从命令提示符安装 SQL Server Analysis Services
安装 SQL Server Integration Services
使用安装程序安装 SQL Server Integration Services
从命令提示符安装 SQL Server Integration Services
返回页首
Integration Services
更新的主题
条件性拆分转换64 位计算机上的 Integration Services 注意事项
返回页首
Integration Services 编程
新主题
Building Packages ProgrammaticallyCreating an ODBC Destination with the Script Component
Developing Specific Types of Script Components
Enhancing an Error Output with the Script Component
Extending Packages with Custom Objects
Extending Packages with Scripting
Integration Services Error and Message Reference
Logging and Defining Log Entries in a Data Flow Component
Mapping Data Types in the Data Flow
Parsing Non-Standard Text File Formats with the Script Component
Detecting an Empty Flat File with the Script Task
Gathering a List for the ForEach Loop with the Script Task
更新的主题
Adding Tasks ProgrammaticallyCoding and Debugging the Script Component
Configuring the Script Component in the Script Component Editor
Developing a User Interface for a Data Flow Component
Developing a Custom Data Flow Component
Developing a Custom Data Flow Component
Extending the Data Flow with the Script Component
Integration Services Programming
Loading the Output of a Local Package
Loading and Running a Local Package Programmatically
Transformation Custom Properties
Using Error Outputs in a Data Flow Component
Using Property Expressions to Specify Property Values for Data Flow Objects
返回页首
国际化注意事项
- 更新的主题
会话语言
返回页首
Notification Services 编程
- 更新的主题
EventClass Element (ADF)
返回页首
复制
新主题
如何配置发布以允许使用 Web 同步 (SQL Server Management Studio)
返回页首
复制编程
-
How to: Configure a Publication to Allow for Web Synchronization (RMO Programming)
How to: Configure a Subscription to Use Web Synchronization (Replication Transact-SQL Programming)
How to: Configure a Subscription to Use Web Synchronization (RMO Programming)
How to: Define a Logical Record Relationship Between Merge Table Articles (RMO Programming)
更新的主题
How to: Configure Web Synchronization for Merge Replication (Replication Transact-SQL Programming)How to: Configure Web Synchronization for Merge Replication (RMO Programming)
返回页首
Reporting Services
新主题
图表布局帮助主题(报表设计器)Reporting Services 与 Visual Studio 中的 ReportViewer 控件
配置 Reporting Services 以使用 SSIS 包数据
将 Reporting Services 配置为使用 Microsoft .NET Data Provider for mySAP Business Suite
更新的主题
对 XML 输出应用转换
返回页首
Reporting Services 编程
新主题
Creating a Custom Report ItemCreating the Custom Report Item Design-Time Component
Creating the Custom Report Item Run-time Component
Custom Report Item Architecture
Custom Report Item Class Libraries
Deploying a Custom Report Item
返回页首
示例
更新的主题
数组参数示例AsynchronousRender 示例 Windows 应用程序
FindRenderSave 示例 Windows 应用程序
安装和编译 Integration Services 编程示例
Readme_ServiceBrokerConfiguration
返回页首
SQL Server 管理对象 (SMO)
更新的主题
How to: Create a Visual Basic SMO Project in Visual Studio .NETHow to: Create a Visual C# SMO Project in Visual Studio .NET
How to: Set Up a Partition Scheme for a Table in Visual Basic .NET
返回页首
工具和实用工具
更新的主题
数据库引擎优化顾问功能SQL Server Management Studio 中的功能
Business Intelligence Development Studio 中的 Integration Services
介绍 Business Intelligence Development Studio
nscontrol displayargumentkey 命令
返回页首
Transact-SQL
新主题
sys.column_xml_schema_collection_usages (Transact-SQL)sys.dm_db_missing_index_columns
sys.dm_db_missing_index_details
sys.dm_db_missing_index_group_stats
sys.dm_db_missing_index_groups
更新的主题
ALTER ASSEMBLY (Transact-SQL)ALTER PROCEDURE (Transact-SQL)
ALTER REMOTE SERVICE BINDING (Transact-SQL)
column_constraint (Transact-SQL)
column_definition (Transact-SQL)
CREATE DATABASE (Transact-SQL)
CREATE EVENT NOTIFICATION (Transact-SQL)
CREATE FUNCTION (Transact-SQL)
DBCC CHECKALLOC (Transact-SQL)
DBCC CHECKCONSTRAINTS (Transact-SQL)
DBCC CHECKFILEGROUP (Transact-SQL)
DBCC CHECKTABLE (Transact-SQL)
DBCC INPUTBUFFER (Transact-SQL)
DBCC SHOWCONTIG (Transact-SQL)
NSEventBatchList (Transact-SQL)
OBJECTPROPERTYEX (Transact-SQL)
SET TRANSACTION ISOLATION LEVEL (Transact-SQL)
sp_adddynamicsnapshot_job (Transact-SQL)
sp_addextendedproperty (Transact-SQL)
sp_addlinkedsrvlogin (Transact-SQL)
sp_addmergearticle (Transact-SQL)
sp_attach_single_file_db (Transact-SQL)
sp_changearticle (Transact-SQL)
sp_changemergearticle (Transact-SQL)
sp_create_plan_guide (Transact-SQL)
sp_dropextendedproperty (Transact-SQL)
sp_mergearticlecolumn (Transact-SQL)
sys.database_recovery_status (Transact-SQL)
sys.dm_db_index_operational_stats
sys.dm_db_index_physical_stats
sys.dm_db_mirroring_connections
sys.dm_exec_query_optimizer_info
sys.dm_tran_active_snapshot_database_transactions
sys.dm_tran_current_transaction
sys.dm_tran_top_version_generators
sys.dm_tran_transactions_snapshot
sys.server_event_notifications (Transact-SQL)
sys.sysprocesses (Transact-SQL)
返回页首
教程
返回页首
用户界面参考
返回页首
配置管理的 WMI 提供程序
更新的主题
SetServiceAccountPassword Method (SqlService Class)SetStartMode Method (SqlService Class)
返回页首
请参阅
概念
以前的联机丛书版本中的新的和已更新的主题
新的和已更新的联机丛书主题(2006 年 4 月 14 日)