October 11, 2011 at 2:49 pm
Hi,
I have a sp that looks like this:
CREATE PROCEDURE [dbo].[TEST]
(
@ServerName VARCHAR(100),
@DatabaseName VARCHAR(100)
)
AS
BEGIN
SET NOCOUNT ON
SELECT * FROM [@ServerName].[@DatabaseName].dbo.Abcd
END
I want to add the [] in front of the Servernames and database name.
The above code fails with the following error below :
Could not find server '@ServerName' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
I have to use it in an execute sql task and get values for these parameters from SSIS variables .
My server name is like for example ServerName\ABCD . So if I donot use the square bracket it will fail.
I have these Variables set up in SSIS .(ServerName and DatabaseName) .
I am not sure how to use them in the stored proc with the [] .
Please help .
October 11, 2011 at 2:52 pm
Duplicate post, please make all responses to http://www.sqlservercentral.com/Forums/Topic1188781-392-1.aspx
CEWII
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy