i'm using this script :

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

but give this error:

Msg 117, Level 15, State 1, Line 1

The object name 'LinkerserverName.DB_Name.dbo.Table_Name' contains more than the maximum number of prefixes. The maximum is 2.

i don't understand how can i use SP to solve this problem ?????