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...

CREATE TABLE [dbo].[Transaction](

[TransactionID] [uniqueidentifier] NOT NULL,

[EmployeeID] [bigint] NOT NULL,

[DateTime] [datetime] NOT NULL,

[Type] [nvarchar](max) NOT NULL,

[OrderType] [nvarchar](2) NULL,

[OrderNo] [nvarchar](50) NULL,

[OrderDate] [datetime] NULL,

[LocationID] [int] NOT NULL,

[IsProcessed] [bit] NOT NULL,

[Manager] [nvarchar](max) NULL,

[CreatedOn] [datetime]...

I attach sample file output file but i don't know where ,

You couldn't create SP from description of table which writes before ???

I uploaded as attachment file ,image from used table and output of it as text file.

Table name is "Transaction"

SELECT [TransactionID]

,[EmployeeID]

,[DateTime]

,[Type]

,[OrderType]

...

That is what i do ,but i need to create fix SP ,give it Time ,from date and after date the give me the Average,

By the way,The table have a...