exec sys.sp_refreshsqlmodule 'dbo.spSimple'
this statement executes on 2005 Standard Edition
but fails on 2005 Developer Edition with:
Invalid EXECUTE statement using object "Module", method "Refresh".
which seems to relate to this line in the system sp
EXEC %%Module(ID = @objid).Refresh()
which is a syntax I do not recognise
Both have same SP and patch levels (and spSimple present on both etc.)
(Logged in as sysadmin on both)
Google isn't helping and there are no posts in this forum related to "sp_refreshsqlmodule"
Any ideas how to resolve this?