Alter trigger script does not include schema
ghanks
Posts: 2
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
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
Thank you for your post into the forum.
This is something that has come up before, could you please see the following forum post :
http://www.red-gate.com/MessageBoard/vi ... hp?p=19659
The information given by Michelle is still relevant.
I hope this helps,
Redgate Foundry