SQL Server Security

[kayek]

I am new to SQL Server.

When I create a database in Enterprise manager it automatically assigns my userid as user named dbo. Since I am a dbo I can not assign my userid to a role. I also can not create myself as a user with my userid (only as dbo userid).

When I open SQL Server I assume it is using my Windows authentication and that is why it assigning dbo to my userid. I want to setup so userid sa is dbo and setup my userid as just a user that I can add to different roles.

 

[Corran007]

EXEC sp_changedbowner 'sa'

Execute that in the database you want to change the owner of. Then you can change your id for the role you want.