quick sp_changeobjectowner script

[RobColborne]

I need to change the owner of some Views after restoring a backup to a different server to user dbo.

Because of the number of views is their any way I can do this quickly rather than having to specifiy each viewname with the sp_changeobjectowner command. For example using a wildcard???

Thanks

 

[mrdenny]

You can create a script and then run that script. Run something like this.

select 'exec sp_changeobjectowner ''' + name + ''', ''dbo'''
from sysobjects
where xtype = 'V'

Run that in Query Analyzer in text mode. Take the output and run that in Query Analyzer and it will change the owner of all the views.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief