Alter trigger script does not include schema

ghanksghanks Posts: 2
edited October 6, 2008 1:01PM in SQL Compare Previous Versions
Generated script does not include the schema in ALTER statement causing the script to fail. However, the schema is included in the preceding PRINT statement (see below)

PRINT N'Altering trigger [Sales].[tr_kr_audit_Affiliate_Del] on [Sales].[Affiliate]'
GO
ALTER TRIGGER [tr_kr_audit_Affiliate_Del] ON [Sales].[Affiliate] FOR DELETE AS
BEGIN

Comments

Sign In or Register to comment.