maybe create a sproc, but always alter it!

IF OBJECT_ID(N'dbo.Create_Response_Packet') IS NULL
BEGIN
   PRINT 'Create procedure : dbo.Create_Response_Packet'
   EXECUTE('CREATE PROCEDURE dbo.Create_Response_Packet AS RETURN 0')
      GRANT EXECUTE ON Create_Response_Packet TO Data_Intercept_Role
END
GO
ALTER PROCEDURE [dbo].[Create_Response_Packet]
(