Fully Qualified Name - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Fully Qualified Name

Author

Topic

MBeal
Posting Yak Master

110 Posts

Posted - 2004-03-24 : 11:30:31

I am trying to pull data from a linked server within my SQL Server Group. Since the object is not on the same server, I need to use the fully qualified name but I must be doing something wrong. It's probably really simple.

Server = Server1
Database = Data1
Table = Table1

I'm using Server1.Data1..Table1 and it's not working. What am I doing wrong?

MBeal

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2004-03-24 : 11:53:28

Are you sure the object is owned by the DatabaseOwner? If not you will need to add the owner of the object to your FQN ... Server1.Data1.ObjectOwner.Table1

You can only skip the owner qualification if the object is owned by the DBO.

Justin

"Hit me with a shovel 'cause I can't believe I dug you."

bmanoj
Starting Member

13 Posts

Posted - 2004-03-24 : 12:04:22

From BOL:
"Always use fully qualified names when working with objects on linked servers. There is no support for implicit resolution to the dbo owner name for tables in linked servers. Because of this, a query without a schema name generates a 7314 error even when the linked server is another instance of SQL Server."

So as I understand you have to specify object owner (schema name) i.e. Server1.Data1.ObjectOwner.Table1

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2004-03-24 : 13:04:01

quote:

From BOL:
"Always use fully qualified names when working with objects on linked servers. There is no support for implicit resolution to the dbo owner name for tables in linked servers. Because of this, a query without a schema name generates a 7314 error even when the linked server is another instance of SQL Server."

Whoops, Looks like I was wrong about DBO being included implicitly. D'oh!

"Hit me with a shovel 'cause I can't believe I dug you."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources