How to use sp_sqlrefreshmodule?

0

Hi to all

I just change the user defined data type from smallint to int .

But i could not access any table it shows following error

"The parameter "@some" is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata. "