There are two ways to remove the binding of a user-defined function to its base objects: Alter the function so that its definition no longer specifies schema binding. Drop the function (then re-create it without schema binding if required).
How do I remove schema bound dependency in SQL Server?
There are two ways to remove the binding of a user-defined function to its base objects: Alter the function so that its definition no longer specifies schema binding. Drop the function (then re-create it without schema binding if required).
Is dependent on database collation the database collation Cannot be changed?
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 ‘CK_Reports’ is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it.
How do I change the database collation in SQL Server?
Alternatively, if the database already exists, right-click the database that you want and select Properties. Select the Options page, and select a collation from the Collation drop-down list. After you are finished, select OK.
