Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gregoryagu
Yak Posting Veteran
80 Posts |
 Posted - 2008-08-19 : 15:43:42
|
| I need to change the database collation from CS to CI. When I try to do so, I get an error message saying that a number of functions in the database are dependent on the collation, and thus it can't be changed.However, in looking at the functions, there seems to be no 'with SCHEMABINDING' clause, nor anything else that would seem to indicate collation binding.The only clue is that all of the fuctions are Table-valued Functions. However, there are other TVF that do not get the same error message, so I don't understand what is different about these five in particular.The only solution I have come up with so far is to drop the functions, then change the database collation, then re-add them.Any suggestions would be appreciated.Greg |
|
|
|
|
|
Collation Dependencies