I use the "USE" Clause at the Beginning of a Stored Procedure only to specify which database the stored proc will reside.

Example:

USE ThisDB

IF EXISTS (SELECT name FROM sysobjects

         WHERE...