Stack Overflow
Stack Overflow

Questions tagged [sql-trace]

8 questions
2
votes
2 answers

How can I include my query in my query results?

I have a SQL Trace that I'm reading through that has ~500 queries in it. I am executing all of the queries against my target db with an output to a text file so I can search for my keyword in the results. I have found the keyword/result one of the…
Fuzz Evans
  • 2,893
  • 11
  • 44
  • 63
2
votes
1 answer

User-Defined Table Type insertion causing conversion error

Not a duplicate of User-Defined Table Type insertion sometimes causing conversion error I have a user defined table type: CREATE TYPE [dbo].[udtImport] AS TABLE( Name varchar(256) null Code varchar(32) null StartDate …
callisto
  • 4,921
  • 11
  • 51
  • 92
1
vote
1 answer

ST05 shows FLAG=N"X" in S/4HANA system. Why?

We are comparing performance between a classic R/3 and a S/4 system, and simple selects from standard function modules ( e.g. selecting records from an IDoc table ) look different in S/4. The most interesting things are those: The S/4 brings less…
icbytes
  • 1,831
  • 1
  • 17
  • 27
1
vote
1 answer

SQL Server Profiler vs COALESCE (SP:STMTCOMPLETED)

I was running a trace and found something that I don't understand. I have a procedure with a simple select statement that returns the first non-null value from a sequence of function calls. I would expect each function to be called only once.…
EduardoCMB
  • 392
  • 2
  • 17
0
votes
1 answer

EXECUTE AS USER in DB2

We are trying to debug a very old web application that uses DB2. I would like to run a trace to see what happens when I click on a button but as soon as I try I receive this error: create event monitor ........ for statement where AUTH_ID='.......'…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
0
votes
0 answers

Why is there a delay between the end time of one task and the start of the next task in SQL Server Trace

We are seeing much slower performance in production vs. QA when running the same queries with basically the same data. We have run traces with a DBA for both QA and production. The traces don't show any issues with any of the queries. However, I…
Weste
  • 79
  • 1
  • 5
0
votes
0 answers

SQL Server : DefaultJob on ServerRestart or Start

I want to give our IT a hand regarding the creation of a DefaultJob, that executes himself every server restart or start (Windows SQL Server 2012) There is a trace that always activates himself after the server restarts or starts (after a hard…
A_ben
  • 29
  • 6
0
votes
1 answer

SQL Server Trace not capturing all Audit Add DB User events

In the SQL Server Audit Add DB User Event Class, there are four Event Sub Classes defined: Add Drop Grant database access Revoke database access (MS documentation found here) When I set up SQL Server Profiler to trace the Audit Add DB User Event…
Zerker
  • 125
  • 7