UPPER Case keywords and CS Collation

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

UPPER Case keywords and CS Collation

Postby netblazer » Thu Nov 20, 2008 2:19 pm

I just got on a CS server. I hit the UPPER CASE function in refactor. Then I got an error (sysname is not a recognisez variable or something).


That's because in the system tables, sysname is in lower cases. And if you don't type it in lower case, sql server won't find it.


You guys might have to add a collation check on the db to see wether or not you can upper case sysname!
netblazer
 
Posts: 3
Joined: Sun Sep 09, 2007 3:57 pm

Postby Ben Pinchen » Tue Nov 25, 2008 1:59 pm

Thanks for bringing this issue to our attention. I've successfully recreated the issue and raised it as a bug in our tracking software. The developers will look into this when working on the uppercasing functionality of SQL Refactor.

For your reference the bug tracking code is: SR-829
Ben Pinchen
 
Posts: 157
Joined: Thu Dec 28, 2006 1:21 pm
Location: Red Gate


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests