problem with enable change data capture

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

problem with enable change data capture

Author

Topic

sebastian11c
Posting Yak Master

129 Posts

Posted - 2011-12-22 : 10:34:56

hi there , i was trying to execute this in my database "ultrasinapsys"

exec sys.sp_cdc_enable_db

but i get this

error

"
Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 186
Could not update the metadata that indicates database UltraSinapsys is enabled for Change Data Capture. The failure occurred when executing the command 'SetCDCTracked(Value = 1)'. The error returned was 15517: 'Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.'. Use the action and error to determine the cause of the failure and resubmit the request.
Msg 266, Level 16, State 2, Procedure sp_cdc_enable_db_internal, Line 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Msg 266, Level 16, State 2, Procedure sp_cdc_enable_db, Line 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Msg 3998, Level 16, State 1, Line 1
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back""

anyone can help me, please,, i reaaly need solve this

i dont know whats wrong with database "ultrasynapsis", because i run the instruction in my other databases and works good

thanks in advanced

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-22 : 10:54:34

do a DBCC CHECKDB?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

sebastian11c
Posting Yak Master

129 Posts

Posted - 2011-12-22 : 13:03:07

IM A NEWBIE, AND SORRY, BUT I DONT GET IT?
how could i do a DBCC CHECKDB??
could u give me an example please

thanks a lot

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-22 : 13:09:13

do you know what that system stored procedure does?

Is this a distributed database?

Are you a member of the sysadmin role?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

sebastian11c
Posting Yak Master

129 Posts

Posted - 2011-12-22 : 15:31:24

i am a sa admin, the instruction command runs in all my other databases , but in "ultrasinapsys database doesnt work"

i know what system stored procedure does is
, but i dont know what Is this a distributed database

and i am member of the sysadmin role,,

how could i fix the error that i get

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-22 : 15:46:27

did you look into Books online???

I'm thinking this is pretty straight forward

>>'Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.'.

Go Google that

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Sachin.Nand

2937 Posts

Posted - 2011-12-22 : 22:53:46

Oh Please...A sysadmin who does not know what a CheckDb is ???

This is going to end in disaster.

PBUH

sebastian11c
Posting Yak Master

129 Posts

Posted - 2011-12-23 : 11:14:44

im a newbie, so i donth have to know it, thats what im asking for help,, im still having problems with enabling cdc ,,

thanks for your help

sebastian11c
Posting Yak Master

129 Posts

Posted - 2011-12-26 : 08:19:41

hi, i exectuted " DBCC CHECKDB "" and i got this

DBCC results for 'UltraSinapsys'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
DBCC results for 'sys.sysrscols'.
There are 1284 rows in 15 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 192 rows in 2 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 212 rows in 3 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 2 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 1 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 2 rows in 1 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 1 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 18 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 208 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 680 rows in 12 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 2073 rows in 51 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 10 rows in 1 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 34 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 621 rows in 10 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 763 rows in 6 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 1081 rows in 398 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 17 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 372 rows in 3 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 3474 rows in 25 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 97 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 1141 rows in 14 pages for object "sys.syssoftobjrefs".
DBCC results for 'fact_factura_detalle'.
There are 31182 rows in 337 pages for object "fact_factura_detalle".
DBCC results for 'sysdiagrams'.
There are 11 rows in 3 pages for object "sysdiagrams".
DBCC results for 'sys.filestream_tombstone_125959525'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_125959525".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
DBCC results for 'AspNet_SqlCacheTablesForChangeNotification'.
There are 2 rows in 1 pages for object "AspNet_SqlCacheTablesForChangeNotification".
DBCC results for 'Base_SyncSUSImg'.
There are 0 rows in 0 pages for object "Base_SyncSUSImg".
DBCC results for 'fact_cuenta_contable'.
There are 18 rows in 1 pages for object "fact_cuenta_contable".
DBCC results for 'Terceros_Base'.
There are 291240 rows in 4900 pages for object "Terceros_Base".
DBCC results for 'Particulares_riv_agos_22_28'.
There are 93 rows in 2 pages for object "Particulares_riv_agos_22_28".
DBCC results for 'Inspeccion_Base'.
There are 350679 rows in 2882 pages for object "Inspeccion_Base".
DBCC results for 'Tree_ElementsRel'.
There are 0 rows in 0 pages for object "Tree_ElementsRel".
DBCC results for 'Base_DataSources'.
There are 1 rows in 1 pages for object "Base_DataSources".
DBCC results for 'Base_SyncTblActions'.
There are 2119788 rows in 24405 pages for object "Base_SyncTblActions".
DBCC results for 'Reportes_ParConfig'.
There are 236 rows in 11 pages for object "Reportes_ParConfig".
DBCC results for 'usuarios'.
There are 1 rows in 1 pages for object "usuarios".
DBCC results for 'fact_sucursal_padre'.
There are 13 rows in 1 pages for object "fact_sucursal_padre".
DBCC results for 'Base_SyncTblVersion'.
There are 15 rows in 1 pages for object "Base_SyncTblVersion".
DBCC results for 'Terceros_Relacion'.
There are 14455 rows in 87 pages for object "Terceros_Relacion".
DBCC results for 'Customers'.
There are 3 rows in 1 pages for object "Customers".
DBCC results for 'fechas_cambio'.
There are 0 rows in 0 pages for object "fechas_cambio".
DBCC results for 'Base_Mapeos'.
There are 56 rows in 1 pages for object "Base_Mapeos".
DBCC results for 'Terceros_Contactos'.
There are 291212 rows in 3562 pages for object "Terceros_Contactos".
DBCC results for 'opt_servicios_parametros'.
There are 19 rows in 1 pages for object "opt_servicios_parametros".
DBCC results for 'Usuarios_Base'.
There are 511 rows in 10 pages for object "Usuarios_Base".
DBCC results for 'suraOctubre11Noviembre'.
There are 14610 rows in 1895 pages for object "suraOctubre11Noviembre".
DBCC results for 'opt_servicios_carroceria'.
There are 14 rows in 1 pages for object "opt_servicios_carroceria".
DBCC results for 'opt_grupoeval'.
There are 21 rows in 1 pages for object "opt_grupoeval".
DBCC results for 'Base_Localizacion'.
There are 1143 rows in 14 pages for object "Base_Localizacion".
DBCC results for 'nov28_util'.
There are 3 rows in 1 pages for object "nov28_util".
DBCC results for 'Tree_ElementAnswers'.
There are 2 rows in 1 pages for object "Tree_ElementAnswers".
DBCC results for 'opt_grupoeval_servicios_carroceria'.
There are 26 rows in 1 pages for object "opt_grupoeval_servicios_carroceria".
DBCC results for 'liberty'.
There are 261 rows in 5 pages for object "liberty".
DBCC results for 'opt_items'.
There are 240 rows in 2 pages for object "opt_items".
DBCC results for 'Base_NotaImagen'.
There are 3466791 rows in 44789 pages for object "Base_NotaImagen".
DBCC results for 'Base_MaestroTipos'.
There are 44 rows in 1 pages for object "Base_MaestroTipos".
DBCC results for 'opt_control'.
There are 21 rows in 1 pages for object "opt_control".
DBCC results for 'opt_control_elementos'.
There are 202 rows in 2 pages for object "opt_control_elementos".
DBCC results for 'Terceros_Tipo'.
There are 524305 rows in 1530 pages for object "Terceros_Tipo".
DBCC results for 'Tree_Trees'.
There are 10 rows in 1 pages for object "Tree_Trees".
DBCC results for 'opt_items_control'.
There are 191 rows in 1 pages for object "opt_items_control".
DBCC results for 'Vehiculo_Base'.
There are 350750 rows in 7269 pages for object "Vehiculo_Base".
DBCC results for 'Usuarios_Perfiles'.
There are 505 rows in 3 pages for object "Usuarios_Perfiles".
DBCC results for 'cambios_inspeccion'.
There are 25 rows in 2 pages for object "cambios_inspeccion".
DBCC results for 'Tree_ElementAnsDetails'.
There are 58 rows in 1 pages for object "Tree_ElementAnsDetails".
DBCC results for 'sura'.
There are 0 rows in 0 pages for object "sura".
DBCC results for 'Tree_Options'.
There are 34 rows in 1 pages for object "Tree_Options".
DBCC results for 'opt_serviciosexc'.
There are 0 rows in 0 pages for object "opt_serviciosexc".
DBCC results for 'Base_Objetos'.
There are 32 rows in 1 pages for object "Base_Objetos".
DBCC results for 'cambios_inspeccion_base_fechas'.
There are 2 rows in 1 pages for object "cambios_inspeccion_base_fechas".
DBCC results for 'Base_Permisos'.
There are 61 rows in 1 pages for object "Base_Permisos".
DBCC results for 'Codigos_Fasecolda'.
There are 11139 rows in 105 pages for object "Codigos_Fasecolda".
DBCC results for 'Tree_Elements'.
There are 14119 rows in 266 pages for object "Tree_Elements".
DBCC results for 'Codigos_Valores_Fasecolda'.
There are 422628 rows in 1830 pages for object "Codigos_Valores_Fasecolda".
DBCC results for 'Inspeccion_Seguimiento'.
There are 2127301 rows in 9888 pages for object "Inspeccion_Seguimiento".
DBCC results for 'Log_consultas'.
There are 472244 rows in 4223 pages for object "Log_consultas".
DBCC results for 'fact_inspeccionesnofacturables'.
There are 313 rows in 6 pages for object "fact_inspeccionesnofacturables".
DBCC results for 'Inspeccion_Servicios'.
There are 466870 rows in 1935 pages for object "Inspeccion_Servicios".
DBCC results for 'MailSender_LogEnvio'.
There are 0 rows in 0 pages for object "MailSender_LogEnvio".
DBCC results for 'Inspeccion_Resultado'.
There are 435226 rows in 5360 pages for object "Inspeccion_Resultado".
DBCC results for 'Inspeccion_Base_changes'.
There are 22 rows in 2 pages for object "Inspeccion_Base_changes".
DBCC results for 'Inspeccion_ResultadoImg'.
There are 3458355 rows in 12426 pages for object "Inspeccion_ResultadoImg".
DBCC results for 'Intermediarios_Liberty'.
There are 148 rows in 1 pages for object "Intermediarios_Liberty".
DBCC results for 'Inspeccion_ResultadosProp'.
There are 9528676 rows in 89879 pages for object "Inspeccion_ResultadosProp".
DBCC results for 'Inspeccion_ResultadosAcc'.
There are 411009 rows in 3189 pages for object "Inspeccion_ResultadosAcc".
DBCC results for 'fact_parametros'.
There are 6 rows in 1 pages for object "fact_parametros".
DBCC results for 'Base_Codigos_Analogos'.
There are 26 rows in 1 pages for object "Base_Codigos_Analogos".
DBCC results for 'fact_factura_inspecciones'.
There are 204181 rows in 531 pages for object "fact_factura_inspecciones".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'Vehiculo_Base_changes'.
There are 7 rows in 2 pages for object "Vehiculo_Base_changes".
DBCC results for 'Base_Tipos'.
There are 396 rows in 4 pages for object "Base_Tipos".
DBCC results for 'fact_terceros_atributos'.
There are 118 rows in 1 pages for object "fact_terceros_atributos".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'Terceros_Contactos_changes'.
There are 6 rows in 1 pages for object "Terceros_Contactos_changes".
DBCC results for 'fact_precios_servicios'.
There are 397 rows in 4 pages for object "fact_precios_servicios".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'fact_consecutivos_oficina'.
There are 15 rows in 1 pages for object "fact_consecutivos_oficina".
DBCC results for 'Base_Consecutivos'.
There are 1 rows in 1 pages for object "Base_Consecutivos".
DBCC results for 'fact_factura_encabezado'.
There are 22165 rows in 429 pages for object "fact_factura_encabezado".
DBCC results for 'Tree_ElementOptions'.
There are 21 rows in 1 pages for object "Tree_ElementOptions".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'UltraSinapsys'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

someone could help me to fix the problem to enable cdc

thanks a lot

Sachin.Nand

2937 Posts

Posted - 2011-12-26 : 23:48:34

Try this


USE ultrasinapsys
GO
sp_changedbowner 'sa'
GO

http://support.microsoft.com/kb/913423

PBUH

sebastian11c
Posting Yak Master

129 Posts

Posted - 2011-12-27 : 09:09:23

thanks a lot Sachin.Nand
now works great the cdc

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2011-12-27 : 18:34:16

Clever...

=======================================
Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources