Using the @ symbol in an SP name

• Atat Rowcount

  Default port

  Points: 1453

  More actions

  April 12, 2010 at 8:44 am

  #213780

  Hi

  I've several stored procedures with names in which I use the @ symbol. To date this has caused me no problems.

  Since upgrading to SQL 2008, they still work, however when comparing databases using RedGate SQL Compare, the name causes a problem.

  Example : SP Name GetMessageTemplate@10

  In RedGate, my old SQL2000 database appears with the correct name [GetMessageTemplate@10], however the same SP in the new SQL2008 database appears with the name [GetMessageTemplate@10]@10 - the @10 bit appears *again* after the SP name, causing the script to fail.

  Very odd problem - any ideas? Apart from telling me not to use @ symbols in my names 🙂

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  April 12, 2010 at 9:33 am

  #1150128

  Sounds like a bug in RedGate SQL Compare. Contact them and ask them if there is a fix.