August 1, 2008 at 2:34 pm
hi members,
how to create a table in a different server apart from the server your working
thanks,
sainath
August 1, 2008 at 3:47 pm
I cannot think of any way that you can do this, without installing some software or service on the remote server. I think that you will have to connect to the remote server.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 1, 2008 at 4:04 pm
rbarryyoung (8/1/2008)
I cannot think of any way that you can do this, without installing some software or service on the remote server. I think that you will have to connect to the remote server.
The only thing I can think of is to use a linked server and execute a procedure on the remote server that creates the table for you.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
August 1, 2008 at 5:25 pm
Right. Similar to what I was thinking of: somehow you have to get that code over there in the first place to handle it for you.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply