An Evil Miracle :: Experiments in Requirements Elicitation Rotating Header Image

September, 2006:

SQL Change owner of objects

One might need to change the owner of objects in a whole database, especially after a restore. The following are helper stored procedures that one may use to change ownership of a whole set of objects from one owner to another. The list below code are for Routines, Tables and Single items.