How can I copy a table to another server. It's a linked server. I used this code, but it is not working.
INSERT INTO [E-SVR].enrollmentCollege.CDDT_MSTR (position_id)
SELECT position_id FROM LETRAN.enrollmentCollege.CDDT_MSTR
Thank you.
-
Elaborate on "it is not working"? Are you linking from to a remote SQL server?sam yi– sam yi2014-02-09 04:51:37 +00:00Commented Feb 9, 2014 at 4:51
-
Take a look at this link... stackoverflow.com/questions/4091960/…sam yi– sam yi2014-02-09 04:54:23 +00:00Commented Feb 9, 2014 at 4:54
-
I get this error. Could not find server 'LETRAN' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. How can I do that?Nozella– Nozella2014-02-09 04:59:37 +00:00Commented Feb 9, 2014 at 4:59
-
I under the impression... from your post that the linked server has already been created. Is that not correct?sam yi– sam yi2014-02-09 05:03:20 +00:00Commented Feb 9, 2014 at 5:03
-
I thought it was already linked, but when I executed your given codes, I get that error so I assume it is not yet linked.Nozella– Nozella2014-02-09 05:05:14 +00:00Commented Feb 9, 2014 at 5:05
Add a comment
|
3 Answers
try this.
INSERT INTO [E-SVR].[enrollmentCollege].[dbo].CDDT_MSTR (position_id)
SELECT position_id FROM [LETRAN].[enrollmentCollege].[dbo].CDDT_MSTR
1 Comment
Nozella
Thank you, but I think "LETRAN" server name is incorrect because I get this error.. "Could not find server 'LETRAN' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. "
Try this.
INSERT INTO enrollmentCollege..CDDT_MSTR (position_id) SELECT position_id FROM LETRAN.enrollmentCollege..CDDT_MSTR
Comments
When you are using a 4-part name for a table (which you have to so to use a linked server as part of the name), you need to specify the schema (the 3rd part) as well:
INSERT INTO [E-SVR].enrollmentCollege.dbo.CDDT_MSTR (position_id)
SELECT position_id FROM LETRAN.enrollmentCollege.dbo.CDDT_MSTR
If you want to use the default schema, you can leave the schema part empty:
INSERT INTO [E-SVR].enrollmentCollege..CDDT_MSTR (position_id)
SELECT position_id FROM LETRAN.enrollmentCollege..CDDT_MSTR
3 Comments
Nozella
I execute "select * from sys.servers" and get the server name "LETRAN" But, i still get this error.. "Could not find server 'LETRAN' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. "
Szymon
OK, have you linked this server?
Nozella
I think not yet, I get this error. Could not find server 'LETRAN' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.