Home / server / Questions / 158296
Accepted
laurens
Asked: 2010-07-08 09:56:48 +0800 CST

View database info of other instance installed on the local computer

  • 772

This is my problem: I have a local server with 2 SQL instances. How can I get info from a table in the other instance (while I'm connected to the first instance)? I believe this is possible but then this database is only read-only.

Thanks in advance! a

sql-server

2 Answers

  1. Use Openrowset.

    • 0
  2. Best Answer

    If you just want to view the table using SQL Server Management Studio then just open up another connection in object explorer and enter the details for the other instance.

    If you need to access the information via TSQL on the first instance (if you're doing cross database joins for example) then you'll likely need to explore linked servers.

    • 0