July 18, 2018 at 8:28 am
Trying to give information as to what I am dealing with so Please offer advice only and not flame!!!!
I'm using SQL Server Profiler version 17.8.1 connecting to a SQL 2014 server.
I have or at least I think I have captured everything from the server that should be a sql call, stored proc, view, etc. basically anything in the TSQL Area. I have a large select statement before an Insert INTO statement of a temp table within the database.
I am trying to figure out where the insert statement is getting built from. I thought it would be from the the previous select however it is not.
I think the problem is that the temp table is inside of the database and is truncated after a report we are trying to reverse engineer is completed.
This will solve the problem of having to manually run this report nightly which requires a person to logon and run it.
Could anyone advise as to how to capture everything that's getting sent to SQL or suggest a filter.
I have filtered out all other databases other then the one I am working on and the tempdb incase it's building a temp table in tempdb.
I have attached the TRC file template so If someone could help I would greatly appreciate it.
July 18, 2018 at 9:21 am
Just out of curiosity, do you have access to the actual code you are trying to work with or is this the only way for you to get to the code?
July 18, 2018 at 9:33 am
No it's specific software and the code is compiled and would have no idea where to start if I had access to it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply