We performed a restore of a bunch of databases from another server and now when i try to go in and change the sa pwd i get the following error:
Error 21776: [SQL-DMO] The name 'XXXX' was not found in the Users collection. If the name is a qualified name, use  to separate various parts of the name, and try again.
Now i run the query below to isolate the orphaned users and i get none!
select u.name from master..syslogins l right join
sysusers u on l.sid = u.sid
where l.sid is null and issqlrole <> 1 and isapprole <> 1
and (u.name <> 'INFORMATION_SCHEMA' and u.name <> 'guest'
and u.name <> 'system_function_schema')
- So now i am at a complete loss as to what to do next.
If anyone has any ideas it wil be great!