Post reply

TSQL for fully qualified name

  • May 26, 2009 at 7:47 am

    #137979

    I've created a linked server to a default instance if SQL 2000 from a named instance of SQL 2005.

    I can see the linked server and it's objects under my security node in SQL 2005

    When I try to query the linked server using my fully qualified name

    e.g.

    SELECT PrimProcID

    FROM VSGNNE2K.VSGNNE.dbo.tblPreOP

    I get the following message:

    Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "VSGNNE2K"

    Many thanks ahead of time for any help you can provide

  • May 26, 2009 at 8:01 am

    #999896

    Try this:

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

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

  • May 26, 2009 at 8:08 am

    #999900

    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

  • May 26, 2009 at 4:17 pm

    #1000236

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

    Andrew

  • May 26, 2009 at 4:32 pm

    #1000243

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

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • May 27, 2009 at 7:04 am

    #1000554

    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

  • May 29, 2009 at 7:43 am

    #1002050

    Jeffrey Williams,

    You rock!

    instcat.sql was the solution

    Thanks so very much again!

    Phunhog

  • May 29, 2009 at 9:18 am

    #1002119

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

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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