Post reply

How to make compilation of SP not case sensitive

  • September 14, 2004 at 9:22 am

    #86410

    Hi All,

    I have a sp that works fine in server A and does not compile on server B

    CREATE   FUNCTION [dbo].[fn_MyFunction] (@aParam DEC(10,3))

    RETURNS INT

    BEGIN

    DECLARE @caseSensitive INT

    SET @CASESENSITIVE  = @aParam 

    RETURN @caseSensitive

    END

    Ok this is not the sp but the problem is with case because when I change it to the same case then it compiles fine.

    Thanks for your input.

    Sylvain

  • September 14, 2004 at 9:43 am

    #522994

    Ok I think I have a probleme with the way server B was installed.

    Server A has SQL_latin_General_CP1_C1_AS collation and Server B has SQL_latin_General_CP437_C1_AS ( withc I presume is case sensitive )

    How do I change collation of a server?

  • September 14, 2004 at 11:18 am

    #523013

    I will repost my question with a different title

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply