default db no more- how to recover
is this query good to find which logins have default database that is no more
select * from master..syslogins where dbname not in (select name from sysdatabases)
how do you recover from situations like these?
select * from master..syslogins where dbname not in (select name from sysdatabases)
how do you recover from situations like these?
ASKER
but that is login info, won't be in database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your helpful input.
It is not clear what happened.
If you have any backup of the missing database so after restore all the users get restored also.