I can't drop a user whose name is just number. RRS feed

  • 问题

  • I had a database user named "20130418", and I want to remove it.

    I tried "DROP USER 20130418". It doesn't work.

    I don't think it's caused by the permission, because the same user named "p20130418" can be removed by "DROP USER p20130418".

    The same failure heppened when removing login.

    Can't I name users or logins as a number? How to drop them or remove them with Transact-SQL ?

    2013年4月18日 2:44