UDF dependent on Collation?

[Ovatvvon]

Hi,

I was attempting to change the collation on a database, and it popped up with an error stating that the database collation could not be changed because there are two objects (both are Table-Valued Functions) dependent on the collation.

I didn't see anything within the code, and the UDF's are under the dbo schema.

Does anyone know why they might be restricting me from changing the collation?

-Ovatvvon :-Q

 

[mrdenny]

Schemabinding maybe?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[Ovatvvon]

Shouldn't the dbo schema be able to have its collation changed? What would keep it from being changed?

-Ovatvvon :-Q

 

[mrdenny]

Schema's don't have collations. Databases, tables and columns do. If a table or column is setup to use the database default, and the function has schemabinding to that table, then the server may not allow you to change the collation of the database.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog