Monday, March 16, 2009

Recompiling Database objects programatically

To recompile stored procedure

sp_recompile [@object=] objectname


To compile view use

sp_refreshview @viewname
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)