Post reply

Unable to query new database from linked server

  • February 8, 2012 at 4:11 am

    #251159

    I have a linked server which connects to a sql server A, i have created a database in the Sql Server A & iam unable to query it from the linked server.

    I am able to query all the old databases excpet the new one,Could someone please help ?

  • February 8, 2012 at 5:05 am

    #1444433

    What error are you getting?

    Does the remote user have SELECT privileges on the new database?

    -- Gianluca Sartori

  • February 8, 2012 at 2:39 pm

    #1444800

    Could you please answer Gianluca's questions?



    My blog

  • February 8, 2012 at 7:25 pm

    #1444854

    There may be problem with your query.

    check schema name of table which you are going to access through link server.

    SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'

    AS SchemaTable

    FROM sys.tables

    WHERE NAME='YOUR_TABLE_NAME'

    and then access through that schema

    select * from [server_instance].[database_name].schema_name.your_table_name

    and if you can provide query and error you recieved on running that query.....

Viewing 4 posts - 1 through 3 (of 3 total)

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