Saturday, September 24, 2016

EXEC sp_refreshsqlmodule 'MySprocNameHere'

...will refresh the custom data types (User-defined Table Types at least) a sproc uses. Use this trick when you rename and then recreate a custom data type out from under such a sproc.

No comments:

Post a Comment