Cannot find data type SYSNAME when DB is case sensitive

Aug 25, 2010 at 3:40 PM

When I run your code I get the following error for each variable of type SYSNAME:

Column, parameter, or variable #2: Cannot find data type SYSNAME.

I did some research and discovered that for databases with a case sensitive collation type SYSNAME must be all lower-case. I did a simple find and replace replacing all instances of SYSNAME with sysname and now your code works. I recommend changing this in your released code to help anyone else out who might run into this problem. Thanks.