If you are working with micrsoft SQL i prefer to use the SQL profiler. 2013/2/21 laurent matheo <[email protected]>: > ** > Hi :) > > Thanks a lot, both of you :) > Yep indeed it's a query from overview console on hpd:help desk. > > > Laurent ;) > > > On 21 Feb, 2013,at 06:25 AM, vaibhav wadekar <[email protected]> > wrote: > > ** Yes it's looks like non admin user performing some operation as it > looking for groups to which user belong to. If it is admin user, you might > see short version of SQL. > > > To get complete SQL statement, you can set the parameter Rahul suggested in > ar.cfg > > Regards/Vaibhav > > On Wednesday, February 20, 2013, laurent matheo wrote: >> >> ** >> Hi List ^_^ >> >> I have a little question, when I log "SQL" with ARS it happens that some >> very long SQL queries (like nearly 4k) are "truncated" and finish by "...", >> for example (I just post the begin and the end of it): >> /////////////// >> SELECT COUNT(*) FROM T2120 WHERE ((((T2120.C230000009 = 'ACTIVITY') AND >> (T2120.C1000000427 = 'SGP000000000211') AND (T2120.C7 >= 20) AND (T2120.C7 >> <= 40)) OR ((T2120.C230000009 = 'MAINCHANGE') AND ((T2120.C1000000427 = >> 'SGP000000000211') OR (T2120.C1000000079 = 'SGP000000000211') OR >> (T2120.C1000000079 = 'SGP000000000211')) >> (...) >> OR (T2120.C60900 LIKE '%;20031;%') OR (T2120.C60900 LIKE >> '%;1000000007;%') OR (T2120.C60900 LIKE '%;1000000107;%') OR (T2120.C60900 >> LIKE '%;20000;%') OR (T2120.C60900 L... >> /////////////// >> >> Is there a way to get / log the full SQL query? I mean, apart asking the >> DBA since when we have those logs it's too late to ask them for it. >> >> Best regards. >> >> >> Laurent. >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > -- > Sent from Gmail Mobile > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
