I am working with a server with the collation set to SQL_Latin1_General_CP1_CS_AS . While creating an index on a new table in a new database, the SQL script was case sensitive (the table has a column iCustomer number and the script failed trying to index the column icustomer). I deleted the database and created a new database using SQL_Latin1_General_CP1_CI_AS as the collation and that script worked. Now however another script is attempting to create a stored procedure, however it is declaring a variable @iCustomer and attempts to use the variable as @icustomer and fails. The same scripts have worked on many (>20) SQL servers so I know the scripts work. This is the first SQL server with a collation other than SQL_Latin1_General_CP1_CI_AS. Any ideas?