Home Forums SQL Server 2008 Security (SS2K8) user mapped as dbo RE: user mapped as dbo
SQL Surfer '66
SSCertifiable
Points: 5161
More actions
August 15, 2012 at 3:10 am
#1525918
If I understand the question correctly you have to transfer the ownership to another login before you drop the login:
USE [Your database]
GO
ALTER AUTHORIZATION ON SCHEMA::[dbo] TO [Another login]