Stored procedures

Hi,
which stored procedures are generally called as housekeeping stored procedures?

Please define housekeeping.

Hi Paul,
I'm also confused with that..Is that relate to moving the files to some other location?

It all depends of what you call housekeeping -usually related to clean up the mess left behind during whatever you where working on.

On a front end application you could say "housekeeping" is related to free memory and close database connections...

During table reorganization you could say "housekeeping" is to be sure all invalidated indexes are rebuilt and fresh statistics are gathered...

It all depends of the specific scenario.