Perry Whittle (5/29/2015)
OK, just tested and it seems it does retain the permission when renaming, sorry for the mistake
No problem, but thanks for the confirmation. I thought it did on 2008, but I don't have a 2012 server to test. :unsure:
I guess we're back to the OP's problem. Have you tried executing the sp_rename (as sysadmin or user with alter permissions on the table) without going through your procedure?
If it works and maintains the permissions, can you post the code for the procedure that does the rename?