Home Forums Article Discussions Article Discussions by Author Discuss content posted by Riken Patel Change DB Owner to sa for multiple DB's RE: Change DB Owner to sa for multiple DB's
Riken Patel
SSC Veteran
Points: 253
More actions
April 26, 2013 at 7:28 am
#1610357
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 few problems with it, such as missing databases.