Usually that's what I'm doing when it's on an environment I can access the database. Though sometimes the customer doesn't allow a direct database access ;)
On 21 Feb, 2013,at 02:35 PM, andres tamayo <[email protected]> wrote:
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"
