Access a SQL Server 2000 table from SQL Server 2005 Express database

• julianonunes

  Newbie

  Points: 5

  More actions

  October 6, 2008 at 4:55 pm

  #194392

  I'm creating an integration software that will use 2 databases, the database from the current application and the database for my application.

  The servers where the current application runs, only has SQL Server 2000 installed (and it can't be updated). So I would like to know if is possible to access the objects from this SQL Server 2000 database at my database (SQL Server 2005 Express)?

  Thanks.

• Nikhil Shikarkhane

  Default port

  Points: 1498

  More actions

  October 10, 2008 at 2:34 pm

  #883644

  yes create a linked server.