Qualify Db Name In SQL

Oct 15, 2001

How to qualify the database name in SQL statement
E.g., select * from Database name. table name

View 1 Replies


ADVERTISEMENT

Can You Fully Qualify A Server Name In T-SQL?

Jun 30, 2000

I know that you can fully qualify a database and dbo in a statement, but is it possible to do this for different servers? For example, if you have three different servers registered in Enterprise Manager, can you write a script that could query any of the three servers?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved