>>Yes. the dbo still exists in 2008 and 2008 R2
that's good to know- thanks for confirming it..
>>why don't you build your code with sys.database_principals rather than sysusers? ;)
Surely would like to, once we get rid of the 2000 environment- till then preferred to keep one query across all environments, when possible.. (not my choice)
http://msdn.microsoft.com/en-us/library/aa260592%28SQL.80%29.aspx
in other words, would
select * from sysusers bring back records in R2?