-- %%START%% PROCEDURE.HumanResources.uspUpdateEmployeeLogin
-- **********************************************************************
-- $Workfile:$
-- AUTHOR       : F.QUARATINO
-- DATE CREATED : 06/05/2010
-- REVISION     : $Revision:$
-- DESCRIPTION  : Script to create if non existent then amend SQL Server
--                procedure uspUpdateEmployeeLogin
-- **********************************************************************
-- $Log:$
--
--
USE AdventureWorks
GO
 
IF Object_Id(N'uspUpdateEmployeeLogin', N'P') IS NULL
BEGIN
    EXEC ('CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeLogin] AS BEGIN SELECT 1 END')
END
GO 
 
GO 
Msg 15009, Level 16, State 1, Procedure sp_helptext, Line 54
The object 'uspUpdateEmployeeLogin' does not exist in database 'AdventureWorks' or is invalid for this operation.
GO