• Hugo Kornelis

    The server does not matter, the client does. You need at least the SSMS version that ships with SQL Server 2005. It should work against any version server, as far as I know (but I never tried this).

    Using SQL 2000 - Query Anayser

    Fails with error message "Incorrect syntax near '100'."

    Using SSM 2005 to connect to same SQL 2000 server

    Executes and returns correct answer.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]