How to check if I currently own a database owner for SQL 2000/2005/2008

Question

I can’t remember how to do this in a TSQL query. It was a one-liner suitable for testing before starting DML. The query was similar to SELECT IS_DBO () or SELECT IS (DBO).

Answer 1

You are probably looking for a function IS_MEMBER:

SELECT IS_MEMBER('db_owner')