Red Gate forums :: View topic - Error in Smart Rename when changing table schema
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

Error in Smart Rename when changing table schema

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tkdennis



Joined: 29 Feb 2008
Posts: 75

PostPosted: Thu May 29, 2014 9:09 pm    Post subject: Error in Smart Rename when changing table schema Reply with quote

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 6.3.0.345
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Mon Jun 02, 2014 2:19 pm    Post subject: Reply with quote

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.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
CGLuttrell



Joined: 10 Sep 2009
Posts: 18
Location: Knoxville, TN

PostPosted: Wed Jul 02, 2014 10:47 pm    Post subject: Same error in 6.4.0.167 Reply with quote

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.
Thanks,
Chris
Back to top
View user's profile Send private message AIM Address MSN Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group