May 6, 2010 at 1:36 am
i notice your SP is not enable to generate script of SP that not are in DBO schema.
bye
example:
-- %%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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply