title: How to send a linked server name as a parameter of stored procedure?
body: <p>I'm trying to create a simple stored procedure which queries with Linked server.</p>
  
  <pre><code>create procedure test
  @LinkedServeName nvarchar(20)
  as
  begin
    select * from @LinkedServerName.WorkersDB.tbl_workers
  end
  </code></pre>
  
  <p>What's the solution?</p>