SQL Sever 2005 (YUKON) Review in short, #2
Ok, here is another one:
- I add a login to my database server:
EXEC sp_addlogin @Username, @Password, @Database;
This works fine!
- I add a user, to a database by using the stored prcedure sp_adduser:
Use [MyDB];
EXEC sp_adduser @Username;
This also works fine!
- I want to remove the user from the database. Therefore I use the stored procedure
sp_dropuser
:
EXEC sp_dropuser @Username;
This removes the user BUT what you’ll see while digging deeper is that sp_adduser
has created an SCHEMA and sp_dropuser
don’t cares a s%#t about that - it’s still there after calling sp_dropuser
:-(