KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I want to insert some data on the local server into a remote server, and used the following sql: select * into linkservername.mydbname.dbo.test from localdbname.dbo.test But it throws the following error The object name 'linkservername.mydbname.dbo.test' contains more than the maximum number of prefixes. The maximum is 2. How can I do that?
Tags (comma-separated)
Save Edits
Cancel