David Emerson
newsgrps at dalyn.co.nz
Sun Mar 4 18:08:37 CST 2012
Team, I Have SQL2008 R2. The following function which is saved in the SQL database has the function name underlined in red with the error Invalid Object name. Does anyone know what the problem might be? It seems to be saved in the database under Scalar-valued functions but I can't get rid of the error. USE [iMIS10_MP] GO /****** Object: UserDefinedFunction [dbo].[fn_MobilFuelGetNextSEQN] Script Date: 03/05/2012 13:01:01 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: David Emerson, Dalyn Software -- Created: 5/3/2012 -- ============================================= ALTER FUNCTION [dbo].[fn_MobilFuelGetNextSEQN] <- Error Invalid object name ( ) RETURNS int AS BEGIN DECLARE @Result int, @NewSeqn int EXEC @Result=dbo.sp_iboGetCounter 'Activity',1, at NewSeqn output RETURN @NewSeqn END Regards David Emerson Dalyn Software Ltd Wellington, New Zealand