I will look into that when I get to work.
When I tried to do:
DROP PROCEDURE sp_Test();
CREATE PROCEDURE sp_Test()
I got an error. I believe it said the Create Statement wasn't expected.
Regardless, if the Stored Procedure doesn't exist the first time, it will error out anyway.
The Procedure is not going to change much, so it won't be a big deal.