Using Linked server to create table in other DB

Question

select * into LinkedServer.[DB_Name].[dbo].[Table_Name] 
FROM Server2.[DB2_Name].[dbo].Table2_Name

Give this error message:

(Msg 117, Level 15, State 1, Line 1 The object name 'DMSSQLCLD01.Guarantees.dbo.guarantees' contains more than the maximum number of prefixes. The maximum is 2.)

Unnikrishnan R · Accepted Answer · 2016-10-13 06:16:09Z

2

You can't use a linked server table in SELECT ... INTO since it doesn't supports 4 part name.

You have to create the table and then use INSERT INTO.. for populating the data.

INSERT INTO  LinkedServer.[DB_Name].[dbo].[Table_Name]
SELECT * FROM Server2.[DB2_Name].[dbo].Table2_Name

see the comment from MSDN.You can read more over here

edited Oct 13, 2016 at 6:16

answered Oct 13, 2016 at 6:09

Unnikrishnan R

5,0511 gold badge15 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Linked server to create table in other DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related