if object_Id( '') Is Not Null
drop procedure 
go

CREATE procedure 
as
/*
*************************************************************
Name: 
Description:

Usage:exec 

Author: 

Input Params:
-------------

Output Params:
--------------

Return:

Results:
---------

Locals:
--------
@err		Holds error value

Modifications:
--------------

*************************************************************
*/
set nocount on
declare @err int

select @err = 0
/*
Check parameters and exit if not correct.
*/
if @err = -1
begin
  Raiserror( 'Parameter Error:Usage:exec ', 
12, 1)
  return @err
end

return @err
GO
grant execute on  to WebUser
go
if object_id( '') Is Null
select 'Error: Not Created'
else
select ' Created'
go