quote:

---

Originally posted by mnarewec

Team
I am trying to get data from database in one server and insert into same database in another server.

I linked an instance of SQL Server 2005 (WAI_ISNT_TTS\DEVELOPMENT) to my local SQL Server 2005 Express Ed server (WAIITD91\SQLEXPRESS. It is a default instance)

Here is the script for Link Server:
EXEC sp_addlinkedserver
@server='WAI_ISNT_TTS',
@srvproduct='',
@provider='SQLNCLI',
@datasrc='WAI_ISNT_TTS\DEVELOPMENT'

Here is my script of SQL Insert Statement:
[green]

insert into [WAIITD91\SQLEXPRESS].DatabaseName.FMS(Schema).Regions
select * FROM FMS.Regions

[/green]

However I got this Error when executing the Insert statement Script:
The OLE DB provider "SQLNCLI" for linked server "WAI_ISNT_TTS" does not contain the table ""DEVELOPMENT"."FMS"."Regions"". The table either does not exist or the current user does not have permissions on that table.

Please advise where I went wrong. On the SQL Insert statement script or the Link Server script??

Thanks in advance for your help

Cheers!
Marsh

---