Skip to main content
Database Administrators

Return to Question

increased readility
Source Link
nbk
nbk
  • 8.7k
  • 6
  • 14
  • 27

My error is 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D, because it does not exist or you do not have permission.

I connected to the subscriber database and tried to execute the following query: exec sys.sp_MSaddmergetriggers N'Employees', N'dbo', null, 0 and

exec sys.sp_MSaddmergetriggers N'Employees', N'dbo', null, 0

and got the following error: sp_MS_marksystemobject: sp_MS_marksystemobject:

Invalid object name '[dbo].[MSmerge_ins_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_upd_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_del_9777E7338F8248498F9237E1FF3FE39D]' Msg 15151, Level 16, State 1, Line 20 Cannot find the object 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D', because it does not exist or you do not have permission. Failed to create merge replication triggers for object '[dbo].[Employees]'.

Invalid object name '[dbo].[MSmerge_ins_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_upd_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_del_9777E7338F8248498F9237E1FF3FE39D]' Msg 15151, Level 16, State 1, Line 20 Cannot find the object 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D', because it does not exist or you do not have permission. Failed to create merge replication triggers for object '[dbo].[Employees]'.

Completion time: 2024-10-23T15:03:16.5001483-04:00

What permits do I need?

Maybe the following has some effect: if I execute the following query on the publishers: SELECT * FROM sys.objects WHERE name = 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D'; I

SELECT *
FROM sys.objects WHERE name = 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D';

I get one record, if I execute this query on the subscriber, I don't find a single record

My error is 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D', because it does not exist or you do not have permission.

I connected to the subscriber database and tried to execute the following query: exec sys.sp_MSaddmergetriggers N'Employees', N'dbo', null, 0 and got the following error: sp_MS_marksystemobject:

Invalid object name '[dbo].[MSmerge_ins_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_upd_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_del_9777E7338F8248498F9237E1FF3FE39D]' Msg 15151, Level 16, State 1, Line 20 Cannot find the object 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D', because it does not exist or you do not have permission. Failed to create merge replication triggers for object '[dbo].[Employees]'.

Completion time: 2024-10-23T15:03:16.5001483-04:00

What permits do I need?

Maybe the following has some effect: if I execute the following query on the publishers: SELECT * FROM sys.objects WHERE name = 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D'; I get one record, if I execute this query on the subscriber, I don't find a single record

My error is MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D, because it does not exist or you do not have permission.

I connected to the subscriber database and tried to execute the following query:

exec sys.sp_MSaddmergetriggers N'Employees', N'dbo', null, 0

and got the following error: sp_MS_marksystemobject:

Invalid object name '[dbo].[MSmerge_ins_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_upd_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_del_9777E7338F8248498F9237E1FF3FE39D]' Msg 15151, Level 16, State 1, Line 20 Cannot find the object 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D', because it does not exist or you do not have permission. Failed to create merge replication triggers for object '[dbo].[Employees]'.

Completion time: 2024-10-23T15:03:16.5001483-04:00

What permits do I need?

Maybe the following has some effect: if I execute the following query on the publishers:

SELECT *
FROM sys.objects WHERE name = 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D';

I get one record, if I execute this query on the subscriber, I don't find a single record

edited title
Link
Dmitro
Dmitro
  • 1
  • 1

I'm trying to set up merge replication and I get an error 'MSmerge_ctsv_9777E7338F8248498FD', because it does not exist or you do not have permission

Source Link
Dmitro
Dmitro
  • 1
  • 1

I'm trying to set up merge replication and I get an error

My error is 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D', because it does not exist or you do not have permission.

I connected to the subscriber database and tried to execute the following query: exec sys.sp_MSaddmergetriggers N'Employees', N'dbo', null, 0 and got the following error: sp_MS_marksystemobject:

Invalid object name '[dbo].[MSmerge_ins_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_upd_9777E7338F8248498F9237E1FF3FE39D]' sp_MS_marksystemobject: Invalid object name '[dbo].[MSmerge_del_9777E7338F8248498F9237E1FF3FE39D]' Msg 15151, Level 16, State 1, Line 20 Cannot find the object 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D', because it does not exist or you do not have permission. Failed to create merge replication triggers for object '[dbo].[Employees]'.

Completion time: 2024-10-23T15:03:16.5001483-04:00

What permits do I need?

Maybe the following has some effect: if I execute the following query on the publishers: SELECT * FROM sys.objects WHERE name = 'MSmerge_ctsv_9777E7338F8248498F9237E1FF3FE39D'; I get one record, if I execute this query on the subscriber, I don't find a single record