October 30, 2008 at 2:24 pm
Does anyone have the script (DDL) for a remote server? For example,
I would like to execute a stored procedure in a remote server;
I would like to create a table in a remote server;
I would like to drop a table in a remote server;
The linked server has been configured. DML works, such as SELECT * FROM ServerA.master.sys.sysdatabases.
Any input will be greatly appreciated.
October 30, 2008 at 7:37 pm
The account with which you are connecting to the linked server needs to have the proper permissions on the linked server and in the database(s) on the linked server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply