Using SQL Server 2005 to connect to SQL Server 2000

Are there any issues with connecting to a SQL Server 2003 database with SS 05 TIA!

David L. Crooks



Answer this question

Using SQL Server 2005 to connect to SQL Server 2000

  • Scoper

    I guess you mean SQL Server 2000, not 2003 as there is no such thing.

    How are you trying to connect At the server level (linked servers etc) or using the client tools

    Nick
    DBA
    www.comoni.co.uk


  • Dan1

    No problem connecting to a 2000 server with 2005 client tools. Minor things like problems Modifying UDF might occur but I am complelety satisfied with using 2005 tools on 2000 server.


  • therock

    I would be using the client tools and want to make sure I won't be causing any trouble by connecting to the 'old' server. Thanks!

    David L. Crooks


  • Using SQL Server 2005 to connect to SQL Server 2000