Distributed queries exist

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  January 4, 2011 at 4:16 am

  #243039

  hi,

  We’re having database in SQL Server 2000 and we’ll need to connect to database(SQL server 2005 Express edition) through linked server – because distributed queries exist in stored procedures of SQL Server 2000 .

  I doubt whether this will be possible if target database is in SQL Server 2005 express edition required or same SQL Server 2000 can able to create linked server?

  Or

  Can we create dynamice connection through "OPENROWSET" command?

  Thanks for your help

  ananda

• Iulian -207023

  SSCertifiable

  Points: 7639

  More actions

  January 4, 2011 at 6:14 am

  #1268887

  Hi Ananda,

  I can not find this explicitly stated in MSSQL 2000 documentation

  but if there are data drivers on the server I see no reason why it would not work.

  Another option is to create an ODBC connection to the MS2005 and use it in MSSQL2000 for linked server.

  Regards,

  Iulian