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

No comments:

Post a Comment