Good spot on the spaces issue.

Not sure how you are thinking of doing it without a temp table, there would be a few ways but they would not be as...

sp_changedbowner is an old procedure which may be removed in future release.

sp_msforeachdb is undocumented so would rather not use in a production system, particularly as I have heard of a...

Well said. When I read the first part of your paragraph I was shocked to see that I am being told not to use GOTO.

I had a similar reaction when...