How to check if I'm currently the 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, good for testing before running DML. The query was something similar to SELECT IS_DBO() or SELECT IS(DBO).

Answer 1

You're probably looking for the IS_MEMBER function:

SELECT IS_MEMBER('db_owner')