Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: CREATE TABLE on a linked server

    When trying to create a table on a linked server, I'm getting an error. How can one go about creating a table on a linked server?

    create table TESTSERVER.TESTDB.dbo.test_table
    col_test char(10)
    Server: Msg 117, Level 15, State 1, Line 2
    The object name 'TESTSERVER.TESTDB.dbo.' contains more than the maximum number of prefixes. The maximum is 2.

  2. #2
    Join Date
    Nov 2007

    Try the below if for 2005 :

    exec ('create table TESTDB.dbo.test_table (col_test char(10))') at TESTSERVER

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts