using wildcards doesn't work (SQL2008SP1)

Comments

• Options

  wic Member Posts: 96

  2011-01-28

  I think I've found a "workaround"... maybe a SPx or R3 will fix it...into the near future \:D/
  
  It's a SQL dependend bug.
  
  Change the SQL collation of the DB from Latin1_General_100 to Latin1_General !!
  
  After doing so, I could NOT reproduce the error.
  
  But... a new problem occurs: if you have multiple DB's on the same server (like a dev server), you could have a problem with the schema and owner. (I've something like that!)
  Here the SQL errror:
  >>
  The object 'Cronus$Item Analysis View Budg_ Entry$VSIFT$0' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
  The object 'Cronus$Service Line$VSIFT$0' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation....
  
  ...and so on...
  
  I didn't find the solution so I created a NEW db and restored the NAV backup into it and THEN changed the collation.
  
  any additionnal infos?
  Chris

  #### Only one can survive ######

  0
• Options

  michael_clarendon Member Posts: 2

  2011-02-14

  We've had a similar problem where the executing code couldn't find records when running under a SQL2008 SP1 server but worked happily under SQL2005 SP2. Although the collations were different all problems were resolved after applying SQL2008 SP2, which is available for download.

  0