Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error with SP inside a Not DBO Schema Expand / Collapse
Author
Message
Posted Thursday, May 6, 2010 1:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 18, 2014 12:27 PM
Points: 3, Visits: 140
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
Post #916706
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse