How to send a linked server name as a parameter of stored procedure?

Question

I'm trying to create a simple stored procedure which queries with Linked server.

create procedure test
@LinkedServeName nvarchar(20)
as
begin
  select * from @LinkedServerName.WorkersDB.tbl_workers
end

What's the solution?

score 1 · Accepted Answer · answered Aug 28 '11 at 04:03

1

You would need to use dynamic TSQL.

answered Aug 28 '11 at 04:03

Mitch Wheat

Thanks @Mitch Wheat but I'm looking for the other suggestion. – Raymond Morphy Aug 28 '11 at 04:09
here is a solution for database name (http://stackoverflow.com/questions/3943823/sql-server-how-to-get-a-database-name-as-a-parameter-in-a-stored-procedure) – Raymond Morphy Aug 28 '11 at 04:20
Plus, if you already know the answers why are you asking a question? – Mitch Wheat Aug 28 '11 at 04:22
because this solution is for database name not for linked server name – Raymond Morphy Aug 28 '11 at 04:26
plus, I can't use the use clause for a linked server name so I'm looking for the other solution – Raymond Morphy Aug 28 '11 at 04:26

1 Answers1