Hi, I have run this script! I didn't find it has relation with that user I want to drop!
It's only a database user from windows domain login! The login has been droped!
suneet.mlvy (5/6/2013)
Are u sure there is no DB or schema connected to that user.plz try this.
Use [Master]
select name, default_database_name from sys.sql_logins
go
Use [User_name]
select * from sys.user_token