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
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