I have a scenario in which a user-defined table type has been used as a parameter in multiple stored procedures. This user defined table type has a column with char data type and older collation.
This collation is not suitable to our application and we want to change it to another collation.
What would be the best way to do this? Can we recreate the user defined table type with new collation? if yes, then how to deal with dependent stored procedures?