Toreador (3/26/2014)
It's possible that he is in the wrong context, but we'll assume based on the intro that he is in the correct place.
Nope, based on the preamble
first confirming the login exists on the instance and then finding that it does not exist in the database used by the application
it's clear that although he's in the right context, he's checked the wrong database by mistake.
😉
I agree, being in the wrong database seemed like a much more likely scenario to me.
Especially since there was no use statement preceding the command.
Had the command included a use statement for the appropriate database, then I would have assumed the more obscure answer since there was no mention of a database restore.