Provides intelligent code completion for SQL Server editors.
Moderators: Anu Deshpande, Aaron Law, David Priddle
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 18.104.22.1685
- Posts: 75
- Joined: Fri Feb 29, 2008 1:13 am
Thanks for your post!
I have logged a support ticket for you and emailed you for more details.
- Posts: 692
- Joined: Mon Apr 20, 2009 3:53 pm
- Location: Cambridge
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: 18
- Joined: Thu Sep 10, 2009 9:25 pm
- Location: Knoxville, TN
Return to SQL Prompt 6
Who is online
Users browsing this forum: PDinCA and 0 guests