How to know if a user is the member of the Windows NT group or SQL Server role?

Posted by Abhisek under Sql Server category on | Views : 1894

It returns true or false(1 or 0) depending on whether the user is a member of the specified Windows NT group of SQL Server role.

SELECT IS_MEMBER('db_owner')
It returns 0 on my system.

Comments or Responses

Login to post response