Post reply

Not seeing user tables in linked server's databases

  • September 10, 2008 at 4:14 am

    #382581

    Dear All,

    Am working in sql server 2000. I added a linked server which is SQL server 2005 using 'sa' user. It got connected succesfullly and am able to see all the databases. But am able to see USER TABLES only in one database. In all other database am seeing only system tables.

    Infact the database am seeing (with user tables) in linked server(2005) was restored from one of the database in the server am working (2000). I checked for all the logins. everything seems to be OK...anyways I connected using 'sa' login.

    Wot should I do now..?. Pls help.

    Regards,

    Santhu.

  • September 10, 2008 at 4:22 am

    #869497

    I think this has to do with the schema. SQL Server 2005 uses schema instead of ownership.

    The fully qualified names is somewhat like this

    FOR SQL 2000

    Server_name.catalog_name.Owner.Object_name

    ... just an opinion

    For SQL Server 2005

    Server_name.catalog_name.Schema_name.Object

    Albert B. Matubis
    Database Administrator: Trend Micro PH
    MCP. MCAD. MCDBA. MCT
    MCTS: SQL Server 2005
    MCTS: Business Intelligence
    MCITP: Database Administrator
    MCITP: Business Intelligence Applications Developer

Viewing 2 posts - 1 through 1 (of 1 total)

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