I created a proc that copies data from one server to another. But my server name seems producing an error.
My server name is USER-PC\MSSQLSERVERDEV.
Here's the complete sql that my proc is producing:
INSERT INTO DemoGolf_84_WMS.dbo.PS_DOC_HDR SELECT * FROM USER-PC\MSSQLSERVERDEV.DemoGolf_84_WMS1.dbo.PS_DOC_HDR WHERE DOC_ID = 201141437430
I'm getting an error of:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'USER'.
View Complete Post