3

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).

Andomar
  • 232,371
  • 49
  • 380
  • 404
scottwed
  • 187
  • 2
  • 12

1 Answers1

4

You're probably looking for the IS_MEMBER function:

SELECT IS_MEMBER('db_owner')
LukeH
  • 263,068
  • 57
  • 365
  • 409