Take walk down SQL Lane as he discusses his trials and successes as Sr. SQL Server DBA.
Wednesday, July 07, 2010
Do not use sp_adduser or sp_dropuser use Create User and Drop User because they are being deprecated. Also when you use sp_adduser a schema is created with the user name when used in SQL Server 2005/2008 that is owned by the user. This schema can not be removed without first transferring ownership to dbo with
ALTER AUTHORIZATION ON SCHEMA::[username] TO [dbo] first