sql server 2008 中cdc功能

[zhaojianmi1]

以下代码中，我执行执行最后两句报错：
消息 313，级别 16，状态 3，第 1 行
为过程或函数 cdc.fn_cdc_get_all_changes_ ... 提供的参数数目不足。
请问如何解决
这是一本书里的实例：

/*
Programming Microsoft SQL Server 2008
Chapter 14 - Data Warehousing
*/

-- Change Data Capture (CDC)

-- Create test database
CREATE DATABASE CDCDemo
GO

USE CDCDemo
GO

-- Enable CDC on the database
EXEC sp_cdc_enable_db

-- Show CDC-enabled databases
SELECT name, is_cdc_enabled FROM sys.databases

-- View the new "cdc" user and schema
SELECT * FROM sys.schemas WHERE name = 'cdc'
SELECT * FROM sys.database_principals WHERE name = 'cdc'

-- Create Employee table
CREATE TABLE Employee(
EmployeeId int NOT NULL PRIMARY KEY,
EmployeeName varchar(100) NOT NULL,
EmailAddress varchar(200) NOT NULL)

-- Enable CDC on the table (SQL Agent *should* be running when you run this)

EXEC sp_cdc_enable_table
@source_schema = N'dbo',
@source_name = N'Employee',
@role_name = N'CDC_admin',
@capture_instance = N'dbo_Employee',
@supports_net_changes = 1

-- Show CDC-enabled tables
SELECT name, is_tracked_by_cdc FROM sys.tables

-- Insert some employees...
INSERT INTO Employee VALUES(1, 'John Smith', '[e-mail]')
INSERT INTO Employee VALUES(2, 'Dan Park', '[e-mail]')
INSERT INTO Employee VALUES(3, 'Jay Hamlin', '[e-mail]')
INSERT INTO Employee VALUES(4, 'Jeff Hay', '[e-mail]')

-- Select them from the table and the change capture table
SELECT * FROM Employee
SELECT * FROM cdc.dbo_employee_ct

-- Delete Jeff
DELETE Employee WHERE EmployeeId = 4

-- Results from Delete
SELECT * FROM Employee
SELECT * FROM cdc.dbo_employee_ct
-- (Note: result of DELETE may take several seconds to show up in CT table)

-- Update Dan and Jay
UPDATE Employee SET EmployeeName = 'Dan P. Park' WHERE EmployeeId = 2
UPDATE Employee SET EmployeeName = 'Jay K. Hamlin' WHERE EmployeeId = 3

-- Results from update
SELECT * FROM Employee
SELECT * FROM cdc.dbo_employee_ct -- See note above

-- To access change data, use the CDC TVFs, not the change tables directly
DECLARE @begin_time datetime
DECLARE @end_time datetime
DECLARE @from_lsn binary(10)
DECLARE @to_lsn binary(10)
SET @begin_time = GETDATE() - 1
SET @end_time = GETDATE()

-- Map the time interval to a CDC LSN range
SELECT @from_lsn =
sys.fn_cdc_map_time_to_lsn('smallest greater than or equal', @begin_time)

SELECT @to_lsn =
sys.fn_cdc_map_time_to_lsn('largest less than or equal', @end_time)

SELECT @begin_time AS BeginTime, @end_time AS EndTime
SELECT @from_lsn AS FromLSN, @to_lsn AS ToLSN

-- Return the changes occurring within the query window.

-- First, all changes that occurred...
SELECT *
FROM cdc.fn_cdc_get_all_changes_dbo_employee(@from_lsn, @to_lsn, N'all')

-- Then, net changes, that is, final state...
SELECT *
FROM cdc.fn_cdc_get_net_changes_dbo_employee(@from_lsn, @to_lsn, N'all')

[claro]

用过，但不了解。帮顶

[zhaojianmi1]

用过，怎么做的[Quote=引用 6 楼 claro 的回复:]
用过，但不了解。帮顶
[/Quote]

[dawugui]

没用过2008,只能帮顶.

[zhaojianmi1]

找到如下资料，不知如何解决：

对于要在 TVF 查询中使用的 LSN 界限，最好在使用之前始终对其进行验证。如果端点为 Null 或位于捕获实例有效性间隔之外，则会强制变更数据捕获 TVF 返回一个错误。

如果出现以下某种情况，针对所有更改的查询将返回以下错误：

1用于定义查询间隔的参数无效或超出范围。


2行筛选器选项无效。


消息 313，级别 16，状态 3，第 1 行

为 cdc.fn_cdc_get_all_changes_ ... 过程或函数提供的参数数目不足

为 net changes 查询返回的相应错误如下所示：

消息 313，级别 16，状态 3，第 1 行

为 cdc.fn_cdc_get_net_changes_ ... 过程或函数提供的参数数目不足

[黄_瓜]

xue xi

[ws_hgo]

没有用过sql2008友情帮顶

[zhaojianmi1]

别沉。。。