TSQL for fully qualified name

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Try this:

SELECT * FROM [Servername\InstanceName].database.dbo.table

[font="Verdana"]Markus Bohse[/font]

Phunhog SSCommitted Points: 1562 More actions · Answer 2

Thanks Marcus,

perhaps I was not clear, My linked server is a default instance. There is no named instance of the linked server.

Got another suggestion?

jhh

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 3

Easiest thing to do is open a trace and see how SQL itself is connecting, then just emulate.

Andrew

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 4

Did you update the catalog on SQL Server 2000 by execute the instcat.sql file from the 2005 instance?

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

Phunhog SSCommitted Points: 1562 More actions · Answer 5

Andrew & Jeff

Sincere thanks for your suggestions.

I've never done a trace (but I know what it is), and I'm not aware of the catalog update you suggest Jeff.

Let me do some more reading, and I'll try each suggestion, and then report back.

SQL Server Central forums have done a lot for me and my organization. Your generosity is greatly appreciated!

JH Higgins

Dartmouth Medical School

Hanover NH

Phunhog SSCommitted Points: 1562 More actions · Answer 6

Jeffrey Williams,

You rock!

instcat.sql was the solution

Thanks so very much again!

Phunhog

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 7

You are welcome, I am happy I was able to help.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll