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
asked Apr 26 '11 at 04:52 AM in Default
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?
to solve the problem.
Check this [MSDN/BOL page] for detailed info.: h ttp://msdn.microsoft.com/en-us/library/bb326754.aspx