You may receive this error when replacing an object on the server. This error generally rears its head when the WITH SCHEMABINDING keyword is added. Schema binding limits the changes that can be made to the tables or views that the object refers to.


When Orbital's SQL Decryptor attempts to replace an object on the server, it does so by issuing an ALTER command against the encrypted object. If the SCHEMABINDING keyword is part of the object then the chances that the object gets replaced is slim. In short, you will have to manually replace the object on the server. You can do this by decrypting the object to the decryption window and copy and paste the decrypted code into SSMS. Be aware that in order to get the code to replace you may need to remove or comment out the 'WITH SCHEMABINDING' keywords.


See these links for reference:

http://dba.stackexchange.com/questions/1942/how-do-i-switch-off-schemabinding-for-a-view-without-recreating-it

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163237