Professional Web Applications Themes

Create and Drop tables in a linked server - Microsoft SQL / MS SQL Server

Hi, I have a linked server admin-new, is there a way to create and tables in the linked servers? I tried: drop table [admin-new].master.dbo.tempIDs Got syntax error. Thanks in advance...

  1. #1

    Default Create and Drop tables in a linked server

    Hi,

    I have a linked server admin-new, is there a way to create and tables in
    the linked servers? I tried:

    drop table [admin-new].master.dbo.tempIDs

    Got syntax error.

    Thanks in advance


    Jason Yan Guest

  2. #2

    Default Re: Create and Drop tables in a linked server

    This is not allowed.
    One workaround might be to run a procedure in the remote machine which drops
    the table. I've not tried this, so it may/may not work.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    [url]http://www32.brinkster.com/srisamp[/url]

    "Jason Yan" <liayan> wrote in message
    news:ObQH$eeQDHA.3020TK2MSFTNGP10.phx.gbl...
    > Hi,
    >
    > I have a linked server admin-new, is there a way to create and tables in
    > the linked servers? I tried:
    >
    > drop table [admin-new].master.dbo.tempIDs
    >
    > Got syntax error.
    >
    > Thanks in advance
    >
    >

    SriSamp Guest

Similar Threads

  1. Select data From 3 Linked Tables
    By StylusDesigns in forum Macromedia ColdFusion
    Replies: 12
    Last Post: June 8th, 02:48 AM
  2. LInked Tables...
    By StylusDesigns in forum Macromedia ColdFusion
    Replies: 2
    Last Post: March 4th, 03:56 PM
  3. Linked drop down lists
    By Pete Casey in forum ASP Database
    Replies: 2
    Last Post: May 3rd, 08:33 AM
  4. Performance with linked tables
    By Eddie Simons in forum ASP Database
    Replies: 1
    Last Post: September 25th, 10:46 AM
  5. problems with linked access tables in ASP
    By Laura in forum ASP Database
    Replies: 6
    Last Post: August 20th, 06:22 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139