I appreciate your script, but I've seen problems in SQL 2000 where the login that was the DB owner lost it's access rights after doing this and took down applications as a result. Have anyone had similar experiences and could you please comment on how you resolved it?
Thanks to all for your responses. 🙂
Drive it like you stole it[/size] :w00t: