The documentation on sp_rename says that the table owner and system administrators have permission to execute it. So I think it would be possible to do so using the "grant hidden sa_role" method documented at Rob Verschoor's website http://www.sypron.nl.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.