The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_cdc_enable_db()MetaData:
create procedure [sys].[sp_cdc_enable_db]
as
begin
declare @retcode int
,@containment tinyint
,@db_name sysname
-- Verify SQL Server edition
-- CDC is restricted to Eval, Enterprise and Developer editions
IF (sys.fn_MSrepl_editionid () not in (30,31))
BEGIN
DECLARE @edition sysname
SELECT @edition = CONVERT(sysname, SERVERPROPERTY('Edition'))
RAISERROR(22988, 16, -1, @edition)
RETURN (1)
END
-- Verify caller is authorized to enable change data capture for the database
if (isnull(is_srvrolemember('sysadmin'),0) = 0)
begin
raiserror(22902, 16, -1)
return 1
end
--
-- Contained Database check (Replication is not yet supported on contained databases)
-- If the current database is a contained database, then we error out.
--
SELECT @containment=containment FROM sys.databases WHERE
database_id = db_id()
if (@containment != 0)
BEGIN
set @db_name = db_name()
RAISERROR(12839, 16, -1, @db_name)
RETURN(1)
END
exec @retcode = sys.sp_cdc_enable_db_internal
if (@@error <> 0) or (@retcode <> 0)
begin
return 1
end
return 0
end
No comments:
Post a Comment