June 23, 2010 at 1:01 am
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?
June 25, 2010 at 5:46 am
(delete)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy