<div>
I was just about to delete this. Heres the answer<br />
<br />
This will return no rows if you're out of an app role, and a uid if you're in an app role<br />
<br />
select a.uid<br />
from master..sysprocesses as a<br />
inner join sysusers as b on a.uid = b.uid<br />
where a.spid = @@spid<br />
and b.isapprole = 1<br />
<br />
I think running that select on login before calling sp_setapprole is a better workaround than Microsoft's<br />
<br />
Thanks for the answer though - that is a viable alternative.
</div>


I was just about to delete this. Heres the answer

This will return no rows if you're out of an app role, and a uid if you're in an app role

select a.uid
from master..sysprocesses as a
inner join sysusers as b on a.uid = b.uid
where a.spid = @@spid
and b.isapprole = 1

I think running that select on login before calling sp_setapprole is a better workaround than Microsoft's

Thanks for the answer though - that is a viable alternative.

<div>
Actually my above post didn't work outside of query analyser.<br />
<br />

</div>


Actually my above post didn't work outside of query analyser.



<div>
<div class="content wysiwyg-content">
Is there some way to select (e.g. from the sys tables) the current application role ?<br />
<br />
I have the classic &quot;General Network Error&quot; caused by calling sp_setapprole when the oledb connection.open method returns a pooled connection. (see <a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564" rel="ugc">http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564</a>)<br />
<br />
If I can detect the application role I can stop this error from happening and still get the performance gains of connection pooling which I think we need.<br />
<br />
thanks<br />

</div>
</div>


Is there some way to select (e.g. from the sys tables) the current application role ?

I have the classic "General Network Error" caused by calling sp_setapprole when the oledb connection.open method returns a pooled connection. (see http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564)

If I can detect the application role I can stop this error from happening and still get the performance gains of connection pooling which I think we need.

thanks


How to tell what application role your connection is currently using

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.