none
Client Version of SQL Server Different From Server Version

    Question

  • <span style="font-size:x-small;"> <p>Microsoft SQL Server 2000 - 8.00.2301 (Intel X86) </p><p></p><span style="font-size:x-small;"> <p>Microsoft SQL Server 2000 - 8.00.2301 (Intel X86) </p></span></span>
    Tuesday, April 08, 2014 3:51 PM

Answers

  • I have SQL Server 2008 R2 installed on my office PC and have registered a SQL Server instance that is on a server running SQL Server 2000. When I run a query from my PC against that SQL Server instance, I can't use any of the new data types, commands, etc. available in SQL Server 2008. I hope that's clearer. Thanks.

    How could you use feature that were introduced in 2008 r2 in SQL server 2000.I hope you are talking about running query in SQL Server 2000.

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Tuesday, April 08, 2014 10:25 PM

All replies

  • Hello,

    Could you please describe the issue a little bit more?


    Thank you in advance.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, April 08, 2014 6:40 PM
    Moderator
  • I have SQL Server 2008 R2 installed on my office PC and have registered a SQL Server instance that is on a server running SQL Server 2000. When I run a query from my PC against that SQL Server instance, I can't use any of the new data types, commands, etc. available in SQL Server 2008. I hope that's clearer. Thanks.
    Tuesday, April 08, 2014 9:48 PM
  • I have SQL Server 2008 R2 installed on my office PC and have registered a SQL Server instance that is on a server running SQL Server 2000. When I run a query from my PC against that SQL Server instance, I can't use any of the new data types, commands, etc. available in SQL Server 2008. I hope that's clearer. Thanks.

    How could you use feature that were introduced in 2008 r2 in SQL server 2000.I hope you are talking about running query in SQL Server 2000.

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Tuesday, April 08, 2014 10:25 PM