A user was getting an error 'login failed' it turned out that for the login she was using the 'default database' column was blank and this turned out to have been caused by the copy database wizard when it had detached this database temporarily when making a copy of it. Has anyone else ever seen this problem and is there any way to stop it happening?