Sql trace

[Former Member]

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.

[Former Member]

Hi,

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

Thanks,

Gordon

[Former Member]

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.

[jitin_chawla]

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

[Former Member]

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

[Former Member]

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.