enabling database for replication fails

• Justin Donnelley

  SSC Enthusiast

  Points: 103

  More actions

  June 18, 2009 at 2:40 pm

  #206157

  when clicking "Transactional" under the Publisher properties, I get the following message.

  TITLE: Publisher Properties

  ------------------------------

  An error occurred while saving publication database.

  Do you want to continue saving other changes?

  Database Objects must be created in a schema other than DBO.

  The transaction ended in the trigger. The batch has been aborted.

  Changed database context to 'CADEBILL'. (Microsoft SQL Server, Error: 50000)

  Has anyone come accross this before?

  Thanks!

• Justin Donnelley

  SSC Enthusiast

  Points: 103

  More actions

  June 18, 2009 at 3:07 pm

  #1012081

  Got some help elsewhere, there was trigger that looked at schemas and had to be removed

  IF EXISTS (SELECT * FROM sys.triggers WHERE name = N'Check_Object_Name_Schema' AND parent_class=0)

  DROP TRIGGER [Check_Object_Name_Schema] ON DATABASE

  Thanks to all who looked.