I'm renaming with a user-defined stored proc that has execute as permission to sp_rename.

EXEC dbo.usp_RenameTable 'TableA', 'TableA_HOLD';

EXEC dbo.usp_RenameTable 'TableB', 'TableA';

EXEC dbo.usp_RenameTable 'TableA_HOLD', 'TableB';

Thanks Lynn,

"Yes" to all three of your questions.

Letron

I'm currently working with my DBA to get temporary SHOWPLAN permission. I will reply with details as soon as I can.

Thanks again guys,

Letron

Thanks SSCrazy, but unfortunately I don't have permission to run this on the particular box that is having the issue.

The issue seems to be primarily with the variables however. To be clear, observation 1 never returned...I just cancelled it after 2 min because I knew that it shouldn't...