Perry Whittle (5/29/2015)
if you drop or rename a table the granted permissions will be lost
I thought I remember reading that sp_rename maintained the permissions. Upon re-reading the BOL page, it doesn't say that. Thanks, Perry. I'll file this one away.