• Where is the login located, within the database or within SQL Server? I've seen where a user has permissions on one server, the database is backed up and moved to another server, and that login still exists with rights for the database, even though they don't actually exist on that server.

    Second question: which user are you logged in under when trying to delete the test user?

    --------
    For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
    You can also follow my twitter account to get daily updates: @BLantz2455