Post reply

How to link Databases on MSSQL

  • June 13, 2006 at 6:27 am

    #190945

    Hello

    i need to link two additional databases (MSSQL) into one MSSQL-Database. As of design it is not possible to store all tables in just one DB. Can you tell me wheter this is possible and yes, how?

    Thanks

    Matt

  • June 13, 2006 at 7:31 am

    #643376

    sp_addlinkedserver @server = 'additional_server', @srvproduct = N'SQL Server'

    You might have to play with the parameters (sp_addlinkedserver has up to 7 of them).

  • June 15, 2006 at 4:23 am

    #643899

    I found out that there are no linked tables as in access. Instead DB´s can be accessed with adding the databasename befor the table name...

    Thanks anyway for the reply

  • June 15, 2006 at 2:16 pm

    #644075

    Ahhh they're all on the same server.  Yes, 4 part naming will do the job.

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

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