On May 15, 1:18 pm, imo...@[EMAIL PROTECTED]
wrote:
> i have 2 server Server A and Server B.
> On Server A, I have table Stock :
>
> CREATE TABLE [dbo].[Stock] (
> [Stock_Id] [int] IDENTITY (1, 1) NOT NULL
> ) ON [PRIMARY]
>
> On Server B, I have table Stock too:
> CREATE TABLE [dbo].[Stock] (
> [Stock_Id] [int] IDENTITY (1, 1) NOT NULL
> ) ON [PRIMARY]
>
> i want copy from server A to Server B, using this :
>
> sp_dropserver 'mylink'
> go
>
> sp_addlinkedserver 'mylink', '', 'SQLOLEDB', NULL, NULL, 'DRIVER={SQL
> Server};SERVER=B02;UID=sa;PWD=QWERTY;'
> go
>
> exec sp_serveroption @[EMAIL PROTECTED]
'mylink', @[EMAIL PROTECTED]
'rpc out',
> @[EMAIL PROTECTED]
'true'
> go
>
> EXECUTE [mylink].[serverB].[dbo].[sp_executesql] N'SET IDENTITY_INSERT
> dbo.Stock ON
> INSERT INTO Tr_Stock (Stock_Id) SELECT Stock_Id FROM ( ???? i have
> active in remote server now ??? )Stock
> SET IDENTITY_INSERT dbo.Stock OFF'
>
> but i Still get error.
>
> I think, the problem is when using : EXECUTE [mylink].[serverB].[dbo].
> [sp_executesql] . How to execute insert ?
Sory, i have to remote from local server to remote
server, so i must using set identity on, before execute insert
command.
regards
|
