Can I have the Admin use a different login to the database so I know if SQL activity is from the storefront or the admin?
I tried to modify the web.config as follows:
<appSettings>
<remove key="DBConn"/>
<add key="DBConn" value="data source=myserver;initial catalog=storefront;user id=sfadmin;password=qwerty;persist security info=True;packet size=4096;"/>
<add key="IsAdminSite" value="1"/>
</appSettings>
but no luck. SQL Profiler shows stroefront login during both storefront activity and activity from the admin.