Home > IT Answers > SQL Server > I am getting following error for SQL server 2005/2008
Brijeshkumar
5 pts.
 I am getting following error for SQL server 2005/2008
SQL Server 2005, SQL Server 2008
Hi,
I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\mssql2008 to one of my own stored procedure.
This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL server 2008. I am getting following error
"Incorrect syntax near \."
Does any body know how to pass my server name to the stored procedure?


Software/Hardware used:
ASKED: September 12, 2012  6:35 PM
UPDATED: September 12, 2012  6:54 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Do you need  help on how to “pass” the name, or on how to get it ?

Also, you should post your current code.

carlosdl
 63,535 pts.