Home Forums SQL Server 7,2000 Security What can the role db_ddladmin do? RE: What can the role db_ddladmin do?
Lorelei
SSC Enthusiast
Points: 114
More actions
October 21, 2004 at 1:35 pm
#527531
Thanks!
I modified it to use the existing owner name that I need changed to avoid an Invalid object name error.
if @strOwner = 'existingname'
begin
select @strExecLine = 'sp_changeobjectowner 'existingname.'' + @strName + ''',''dbo'''