Alter trigger script does not include schema

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

ghanks October 03, 2008 19:12

Comments

1 comment

Hi,

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,

Matthew Flatt October 06, 2008 13:01

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Alter trigger script does not include schema

Comments

Add comment