Active Server - Use The Table Owner To Access Other Databases In A Server Group

If you're using ISQL or some other query manager, you don't have to switch from your current database to access the tables in another database. You can simply append the database name and table owner to the table name, like so:

  • Select * From Address_book.dbo.mycontacts

Go back