USE DatabaseName GO

IF OBJECT_ID('StoredProcName') IS NOT NULL BEGIN DROP PROCEDURE StoredProcName IF OBJECT_ID('StoredProcName') IS NOT NULL PRINT '<<< FAILED DROPPING PROCEDURE StoredProcName >>>' ELSE PRINT '<<< DROPPED PROCEDURE StoredProcName >>>' END GO

CREATE PROCEDURE StoredProcName ( @param int = 0 ) AS

-- Description: Stored proc' structure for SQL Server 7.0. -- Developer: rasx

SET NOCOUNT ON

-- This proc' takes advantage of the new security features in SQL Server 7.0.

RETURN GO

GRANT EXECUTE ON StoredProcName TO [Windows NT Group] GO

IF OBJECT_ID('StoredProcName') IS NOT NULL PRINT '<<< CREATED PROCEDURE StoredProcName >>>' ELSE PRINT '<<< FAILED CREATING PROCEDURE StoredProcName >>>' GO