Post reply

Create table on linked server

  • May 12, 2003 at 2:56 pm

    #80220

    I have a msaccess-database as a 'linked server'. everything works fine inserting data into existing tables there.

    But I need to create new tables (e.g. from existing main server tables or views) on that linked server - is there a way to do this using T-SQL?

  • May 12, 2003 at 5:16 pm

    #456903

    Check out BOL topic "OPENQUERY". This allows you to call an insert query from a linked server.

    Darren


    Darren

  • May 13, 2003 at 1:02 am

    #456920

    quote:

    Check out BOL topic "OPENQUERY". This allows you to call an insert query from a linked server.

    thanks darren, but inserting is not the problem - that works as I mentioned above.

    what I need is a "SELECT INTO" which doesnt work with OPENQUERY or OPENDATASET (or I didnt get it to work...) or a way to execute DDL like "CREATE TABLE" there...

    any help is greatly appreciated! thanks harald

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

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