Can you fully qualify a server name in T-SQL?

[babreu]

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?

[Ray Miao]

Create linked server first then you can query it with server_name.db.owner.obj_name.


------------
babreu at 6/30/00 12:51:21 PM

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?