Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Missing owner specification in replication of schema changes

0 views
Skip to first unread message

Rolf

unread,
Jul 23, 2008, 10:50:32 AM7/23/08
to
I have a problem with replicatin schema changes via ALTER TRIGGER.
Wondering why they are transferred correctly, but not executed I found
the problem in the exists clause which preceeds the statement.

Here is the excerpt from the sysmergeschemachange of the subscriber:

if object_id(N'[Trigger_Karteikarten_Ereignisfelder_Update_Delete]') is not
null
exec ('ALTER TRIGGER
[Karteikarten].[Trigger_Karteikarten_Ereignisfelder_Update_Delete] on
[Karteikarten].[Ereignisfelder]
AFTER UPDATE, DELETE NOT FOR REPLICATION
AS BEGIN ...')

As You see the trigger is located on a table that resides in schema of
the owner "Karteikarten". While the owner is not prefixed in the if-clause
the statement never gets executed.

Does anybody knows a hotfix while I guess the error must reside inside the
[sys].[sp_MSmerge_ddldispatcher] or deeper.

Regards,
Rolf

Rolf

unread,
Aug 11, 2008, 11:42:23 AM8/11/08
to
Nobody answering here - not any MVP ? Is this reported as a bug ?
Where can I report bugs in MS software ?

Rolf

unread,
Aug 27, 2008, 10:44:01 AM8/27/08
to
Hoho,

found the thing - but I cannot change system SPs....

--select @temp_ddlcmds = N'if object_id(N'''
+sys.fn_replreplacesinglequote(quotename (object_name(@objid)))+ N''') is not
null exec('''
-- +
sys.fn_replreplacesinglequote('ALTER TRIGGER '
-- + @qual_object_name + N'
on '
-- + @qual_dest_object2 + N' '
-- + @pass_through_scripts )+
N''')'

select @temp_ddlcmds = N'if object_id(N''' +
@qual_object_name + N''') is not null exec('''
+
sys.fn_replreplacesinglequote('ALTER TRIGGER '
+ @qual_object_name + N' on '
+ @qual_dest_object2 + N' '
+ @pass_through_scripts )+
N''')'

0 new messages