Problem: I am getting execute sp_rename in my Alter script. How can I generate alter statements instead?
Solution: you need to check on force alter syntax in the other options
You may have to close your model (this will flush the action log the alter script uses to produce its statements)
Open the model
Make the changes
Now try the Alter Script
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center