Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Refresh roles list for IS_ROLEMEMBER? RE: Refresh roles list for IS_ROLEMEMBER?
kpwimberger
Ten Centuries
Points: 1110
More actions
May 19, 2016 at 4:26 pm
#1880398
Okay, apparently if I change databases and run any query against the new DB, then switch back and run IS_ROLEMEMBER it provides the "refresh" I need, but I would prefer a more elegant solution if anyone knows of one.