Home Forums SQL Server 2005 Administering Must declare the scalar variable "@name". SQL server 2005 RE: Must declare the scalar variable "@name". SQL server 2005

  • May 8, 2008 at 12:07 am

    #812227

    I think Sql Server is having a case-sensitive collation and hence the above error message. You can confirm this by runnning,

    sp_helpsort (or) SELECT SERVERPROPERTY ('Collation')

    [font="Verdana"]- Deepak[/font]