Error in Smart Rename when changing table schema

Provides intelligent code completion for SQL Server editors.

Error in Smart Rename when changing table schema

Postby tkdennis » Thu May 29, 2014 8:09 pm

I am still getting a precedence error (on a view) when I change the schema of the underlying table. Moving the ALTER SCHEMA/TRANSFER statement to before the view eliminates the error.

SQL Prompt version
Posts: 75
Joined: Fri Feb 29, 2008 12:13 am

Postby Anu Deshpande » Mon Jun 02, 2014 1:19 pm

Thanks for your post!

I have logged a support ticket for you and emailed you for more details.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
Anu Deshpande
Posts: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Same error in

Postby CGLuttrell » Wed Jul 02, 2014 9:47 pm

Hi, I just ran into this same issue yesterday. It tried to recreate triggers on the table in the new schema before the ALTER SCHEMA statement. Moving it up also fixed my issue, but this seems like a bug.
Posts: 30
Joined: Thu Sep 10, 2009 8:25 pm
Location: Knoxville, TN

Return to SQL Prompt

Who is online

Users browsing this forum: No registered users and 0 guests