changing object ownership

[shaunakt]

Hi !!I would greatly appreciate your help. I am a newbie at SQL Server..and am a trainee DBA for my company. the problem I am facing is that till now the developers were using any one of three (user created)logins and were creating and manipulating objects. From now on all the creation and modification of objects and databases will be done by me. The problem is that the owners of the previously<br>
created objects is one of those logins.<br>
Is there anyway in which I can become the owner of all the objects and deny them any rights on altering the objects ?? or do I have to drop them all and recreate them with me as the DBO ?? Please advice...

 

[Natraj]

Hi shaunakt,<br>
Try the sp_changedbowner system stored procedure (both 6.5 and 7.0), If it helps. Also mention the type of objects you have.<br>
Natraj