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

CREATE PROCEDURE _newproc ( @cmdName varchar(32) = 'default' )

AS

-- Description: Renames the specified database. -- Developer: rasx@songhaysystem.com IF @cmdName = 'default' BEGIN END

GO

GRANT EXECUTE ON _newproc TO dbWebSolutionsUsers GO

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