Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Smartlists
- Thread starter itasueb
- Start date
clicker666
IS-IT--Management
I'm having the same problem. Here's how I'm tackling it.
I log in as myself (an account with lots of privileges). I setup a SQL trace to observe activity against the SQL server (from me only), then pause it. I get the Smartlist to the point just before I will activate the lookup, unpause the trace, then click the Smartlist. Once the Smartlist has run I stop the trace and start sorting through it for SQL stuff.
Yeah, it's a bit tedious, but it works!
I log in as myself (an account with lots of privileges). I setup a SQL trace to observe activity against the SQL server (from me only), then pause it. I get the Smartlist to the point just before I will activate the lookup, unpause the trace, then click the Smartlist. Once the Smartlist has run I stop the trace and start sorting through it for SQL stuff.
Yeah, it's a bit tedious, but it works!
- Status