Hello Experts,
We have a SQL server which we have with the name 'SELDSQL533\PRD3', on another server i am trying to create a synonym for a particular database and table inside it. but i get a below error for '\'
Is there any escape character to be used to overcome this problem
CREATE SYNONYM Project
FOR SELDSQL533\PRD3.DMS_copy.project
--
Error: Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '\'.
-
/chandresh
use the following query...
CREATE SYNONYM Project
FOR [SELDSQL533\PRD3].DMS_copy.dbo.project
|||Use square brackets [ ] around any name that contains 'unacceptable' characters.
CREATE SYNONYM Project
FOR [SELDSQL533\PRD3].DMS_copy.project
No comments:
Post a Comment