Mike01 and BTeraberry,

Thank you for all your help. I have followed your suggestions in the stored procedure:

1) Removed the GO following the IF EXISTS construct

2) Explicitly referenced the database...

Thanks for the reply. I agree that TRUNCATE makes more sense than doing a drop and recreate. However, I still can not get the IF EXISTS construct to...

I think I have a solution although it is not pretty and probably not the most efficient. I wrote some T-SQL to accomplish what you needed. Following your...