how to sp_refreshsqlmodule with procedure that are prefixed with a schema

When I try EXEC sp_refreshsqlmodule [myschema.myprocedure] i开发者_JS百科t throws Could not find object 'myschema.myprocedure' or you do not have permission.

If the object is schema-bound, then the metadata cannot become outdated because the object is bound to the underlying objects that it references.

EDIT: Based on your edit, the procedure name should be enclosed in single quotes:

EXEC sp_refreshsqlmodule 'myschema.myprocedure'

Found the issue I had to do it like this :

EXEC sp_refreshsqlmodule '[myschema].[myprocedure]'