Mixed mode

Quick test to validate a db connection

Just scratching the surface of 2005 + security. M.S. is known for providing several different ways of accomplishing the same task.

OK, it's obvious I was having a bad day.  Thank you for your reply...I inserted the SET ANSI_NULLS ON before declaring the variables and it worked fine.