Using Profile Trace - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Using Profile Trace

Author

Topic

DavidChel
Constraint Violating Yak Guru

474 Posts

Posted - 2008-07-21 : 17:17:57

I'm trying to determine the steps my ERP system uses when creating new serial numbers for parts in our database. I set the profile trace to respond to the Events
TSQL-SQL:StmtCompleted
Stored Procedures-SP:StmtCompleted

I get the following at the point where the record is saved:

INSERT INTO QALOTC
           (FCTYPE,
            FCDOC,
            FCPARTNO,
            FCPARTREV,
            FCLOT,
            FCUSEINTYPE,
            FCUSEINDOC,
            FCUSEINPART,
            FCUSEINREV,
            FCUSEINLOT,
            FNQUANTITY,
            FCNUMBER,
            FCCOMPANY,
            FDDATE,
            FCMEASURE,
            FAC,
            USEINFAC,
            FCUDREV)
VALUES     (@P1,
            @P2,
            @P3,
            @P4,
            @P5,
            @P6,
            @P7,
            @P8,
            @P9,
            @P10,
            @P11,
            @P12,
            @P13,
            @P14,
            @P15,
            @P16,
            @P17,
            @P18)

The values section are SQL Variables, right? How can I determine how those are figured or can't I because they are part of the ERP Program?

TIA.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-21 : 22:01:46

Looks like insert statement is part of sp, and app passes parameters to the sp.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources