title: SQL Server stored procedure case sensitive?
body: <p>I have a case sensitive SERVER (SQL_Latin1_General_CP1_CS_AS) but the Database is Case insensitive (SQL_Latin1_General_CP1_CI_AS).</p>
  
  <p>If I try to create the following stored procedure on the database, I get the error "Must declare the scalar variable "@test"."</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[sp_Test] (@TEST int) as
  begin   
      SELECT @test
  end
  GO
  </code></pre>
  
  <p>But as I stated the database itself is not case sensitive. Im assuming this is documented somewhere that stored procedures follow the sensitivity of the server but I cannot find a reference anywhere. Can anyone point me to where I would find some docs about this? (Yes I tried google, but im not finding anything)</p>