5.0.1.7 Smart Rename creates incorrect script

Renaming a table that is only used in a trigger that posts updates to a same-named table in another, audit, database generates the change script without reference to the audit database and doesn't recognize the fact that I haven't also renamed the audit database's same-named table (OOPS!). I would have highlighted the missing database qualifier but using the "code" tag stops that...

Old Code:

ALTER TRIGGER &#91;dbo&#93;.&#91;trg_t_site_custom_def_AuditTrigger&#93; ON &#91;dbo&#93;.&#91;t_site_custom_def&#93;
AFTER DELETE,UPDATE
NOT FOR REPLICATION
AS 
BEGIN
	SET NOCOUNT ON;
	INSERT INTO &#91;xcp_ref_audit&#93;.&#91;dbo&#93;.&#91;t_site_custom_def&#93; &#40;&#91;custom_id&#93;,&#91;custom_site_id&#93;,&#91;custom_xml&#93;,&#91;update_date&#93;,&#91;update_by&#93;&#41;
	SELECT &#91;custom_id&#93;,&#91;custom_site_id&#93;,&#91;custom_xml&#93;,&#91;update_date&#93;,&#91;update_by&#93; FROM Deleted
END

New Code:

ALTER TRIGGER dbo.trg_t_site_custom_def_AuditTrigger ON dbo.SiteCustom
AFTER DELETE,UPDATE
NOT FOR REPLICATION
AS 
BEGIN
	SET NOCOUNT ON;
	INSERT INTO dbo.SiteCustom &#40;&#91;custom_id&#93;,&#91;custom_site_id&#93;,&#91;custom_xml&#93;,&#91;update_date&#93;,&#91;update_by&#93;&#41;
	SELECT &#91;custom_id&#93;,&#91;custom_site_id&#93;,&#91;custom_xml&#93;,&#91;update_date&#93;,&#91;update_by&#93; FROM Deleted
END

PDinCA March 15, 2011 14:48

Comments

1 comment

Hi PDinCA,

Thanks for your report. I've logged this in our system as SP-3861.

Regards,
Paul

Paul Stephenson March 16, 2011 04:33

0

Add comment

Please sign in to leave a comment.

How can we help you today?

5.0.1.7 Smart Rename creates incorrect script

Comments

Add comment