Red Gate forums :: View topic - UPPER Case keywords and CS Collation
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

UPPER Case keywords and CS Collation

Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
netblazer



Joined: 09 Sep 2007
Posts: 3

PostPosted: Thu Nov 20, 2008 2:19 pm    Post subject: UPPER Case keywords and CS Collation Reply with quote

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!
Back to top
View user's profile Send private message
Ben Pinchen



Joined: 28 Dec 2006
Posts: 157
Location: Red Gate

PostPosted: Tue Nov 25, 2008 1:59 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group