Re: how to get "full" SQL logs?

2013-02-21 Thread laurent matheo
** 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 wrote:If you are working with micrsoft SQL i prefer to use the SQL profiler. 2013/2/21 laurent

Re: how to get "full" SQL logs?

2013-02-21 Thread andres tamayo
If you are working with micrsoft SQL i prefer to use the SQL profiler. 2013/2/21 laurent matheo : > ** > 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 > wrote: > > ** Yes

Re: how to get "full" SQL logs?

2013-02-20 Thread laurent matheo
** 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 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

Re: how to get "full" SQL logs?

2013-02-20 Thread vaibhav wadekar
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, 2

Re: how to get "full" SQL logs?

2013-02-20 Thread Parekar, Rahul
You can try parameter Enable-Unlimited-Log-Line-Length: T From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Thursday, 21 February 2013 10:33 AM To: arslist@ARSLIST.ORG Subject: how to get "full" SQL logs? ** Hi List ^_^

how to get "full" SQL logs?

2013-02-20 Thread laurent matheo
** 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.C23009 = 'ACTIVITY')