question

varun 1 avatar image
varun 1 asked

How to use sp_sqlrefreshmodule?

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. " I dont know how to solve this error Please help me Thanks in advance
sqllinked-server
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
In the error message it refers to 'the module' - you need to get the name of this, it could be a stored procedure, function, trigger or view. What T-SQL are you executing when you get this error? Then use sp_refreshsqlmodule 'YourModuleName' to solve the problem. Check this [MSDN/BOL page][1] for detailed info. [1]: http://msdn.microsoft.com/en-us/library/bb326754.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.