Question Re: Sql trace in Enterprise Resource Planning Q&A

Sql trace

Former Member — Mon, 29 Aug 2011 10:13:31 GMT

Hello,

Is there somewhere a document that describes the best method to execute a sql trace for Sap Business One? For example, we want to see which tables and columns in Sap Business One administration (sql database) are changed after saving an invoice.

Re: Sql trace

Former Member — Mon, 29 Aug 2011 11:38:33 GMT

Hi,

You just need to run SQL Server Profiler to trace SQL. It is a very simple application to use.

Thanks,

Gordon

Re: Sql trace

Former Member — Mon, 29 Aug 2011 14:29:16 GMT

hi Gordon

the problem is that I can't find it out which settings in the trace are relevant. Now I start the trace (saved as document), quickly go to SAP and add the invoice, than I go back to the trace and stop the trace. After that, I see a lot of information but the tables like oinv, inv1 etc.

Re: Sql trace

jitin_chawla — Mon, 29 Aug 2011 14:42:23 GMT

Hi,

In the Profiler after adding an Invoice, the changes and checks performed for each table involved with the task performed is displayed.

Example in your case when adding an Invoice, the checks will be performed on the tables related to the G\L accounts, BP Code, freight table, tax table, alert, posting period etc etc and then all the numbering table, Item table, accounts, Bp Code when the same is added in the system.

This is the reason why you get a comprehensive list of enteries when you stop the profiler.

The data which you require, you can search from the complete list. Any specific requirement, you can let know.

Kind Regards,

Jitin

SAP Business One Forum Team

Re: Sql trace

Former Member — Tue, 30 Aug 2011 08:14:15 GMT

hi Jitin

I understand that point. Is it possible that you publisch an example of a "profiler trace template"?

I'm special interested in which 'events' you have to select for to get the information which tables/columns are changed.

Edited by: Dan123 on Aug 30, 2011 10:15 AM

Re: Sql trace

Former Member — Tue, 30 Aug 2011 12:14:04 GMT

I am afraid you may not be able to find the information you want. Because B1 uses many SP to post the transaction that the detailed message may be handled within the the application.