Transfer Schema To dbo

[Skittle]

Picture this.

I have a schema that is owned by a UserA.
UserA leaves the company and I have to delete him to keep those ever popular SOX people happy ( ..swines!!!)

I could change the schema to the dbo user or the db_owner role via the Schemas properties. Does it make any difference which?

Dazed and confused

 

[mrdenny]

SQL 2000 or SQL 2005?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

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

http://www.mrdenny.com