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?
September 12, 2012 6:35 PM
September 12, 2012 6:54 PM