Yes, I will post it in about 2 hours.
Thanks
Stephen

Dan, I am sorry but I don't understand your reply.
I listed the information because that is all I know about how I can get this
sp to work... by giving my ADUsers "Domain Admin" rights.
So is it an sp issue or a permission problem? Sorry for not understanding
your reply.

Here is the sp:
USE [Database]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[cf_data_info]
    @table_name varchar(128),
    @column_name varchar(128),
    @data_type varchar(128) OUTPUT,
    @colprecision integer OUTPUT,
    @colscale integer OUTPUT
AS
    SELECT @data_type = systypes.name,
        @colprecision = syscolumns.prec,
        @colscale = syscolumns.scale
    FROM sysobjects
    LEFT OUTER JOIN syscolumns
        ON syscolumns.id = sysobjects.id
    LEFT OUTER JOIN systypes
       
        ON systypes.xusertype = syscolumns.xusertype
    INNER JOIN sysusers
        ON sysusers.uid = sysobjects.uid
        AND Upper(sysusers.name) = 'DBO'
    WHERE sysobjects.name = @table_name
        AND syscolumns.name = @column_name

Everything worked fine before upgrading to SQL 2005 SP2.

Thanks
Stephen