<div>
<br />
SELECT is_rolemember('ROLENAME','<wbr />USERNAME')<wbr /><br />
<br />
<br />
ex.<br />
SELECT is_rolemember('db_owner','<wbr />USERNAME')<wbr />
</div>



SELECT is_rolemember('ROLENAME','USERNAME')


ex.
SELECT is_rolemember('db_owner','USERNAME')

<div>
Brandon<br />
<br />
is my format any issue..<br />
<br />
all of these are returning NULLs<br />
<br />
use tracker<br />
SELECT is_rolemember('db_owner','<wbr />USERNAME')<wbr /> -- your example<br />
SELECT is_rolemember('db_owner','<wbr />SRBSV\jimw<wbr />') -- Domain User Group<br />
SELECT is_rolemember('db_owner','<wbr />tracker_De<wbr />v_Users') --SQL Login
</div>


Brandon

is my format any issue..

all of these are returning NULLs

use tracker
SELECT is_rolemember('db_owner','USERNAME') -- your example
SELECT is_rolemember('db_owner','SRBSV\jimw') -- Domain User Group
SELECT is_rolemember('db_owner','tracker_Dev_Users') --SQL Login

<div>
got it.<br />
<br />
thanks Brandon.
</div>


<div>
<div class="content wysiwyg-content">
like IS_SRVROLEMEMBER helped to verify a server role, is there an equivalent for database role?<br />
<br />
thanks
</div>
</div>


like IS_SRVROLEMEMBER helped to verify a server role, is there an equivalent for database role?

thanks

check database role

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.