Post reply

White Space In SQL Server 2005

  • August 22, 2008 at 8:37 am

    #861937

    I'd find another server at the client level and see if that makes the issue repeatable. Odds are it is the different builds.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • August 22, 2008 at 8:39 am

    #861942

    Frankly, this looks like a SQL Server bug to me. Looks like the later build may have fixed it.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • August 22, 2008 at 9:05 am

    #861968

    OK, it definitely looks like the build.

    I tried my test script on a different database server with the later build and it works as expected.

    Does anyone know if this bug is documented anywhere?

  • August 22, 2008 at 9:31 am

    #861991

    What version? I just ran the code to see what I get... and I have the same mis representation. My version is:

    Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

  • August 22, 2008 at 9:56 am

    #862013

    -- works as expected on the following builds:

    -- Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    -- Microsoft SQL Server 2005 - 9.00.3050.00 (X64) Mar 2 2007 22:06:10 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    --Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 2008 18:15:01 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    -- works incorrectly on the following build:

    -- Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Viewing 5 posts - 16 through 19 (of 19 total)

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