Error with SP inside a Not DBO Schema

  • 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