Mysterious procedure calls without parameters - but no exceptions generatedLong time, sporadic 'String or Binary data would be truncated.' Wisdom would be appreciatedFinding parameter names for binding stored procedure parametersUsing concat inside a stored procedure parametersPass parameters to a procedure with SQLcmdmultiple calls to procedure optimizationHow to create SQL Stored Procedure with parameters of type List<string>Stored Procedure with Optional ParametersFrequent Remote connectivity issue for SQL Server 2008 SP3Find SSIS package which calls stored procedureStored Procedure: table-Value parameters
Why do Russians almost not use verbs of possession akin to "have"?
Public transport tickets in UK for two weeks
The art of clickbait captions
How to politely tell someone they did not hit "reply to all" in an email?
What could a self-sustaining lunar colony slowly lose that would ultimately prove fatal?
My players want to grind XP but we're using landmark advancement
Are black holes spherical during merger?
Of strange atmospheres - the survivable but unbreathable
Is it truly impossible to tell what a CPU is doing?
Why isn't Tyrion mentioned in the in-universe book "A Song of Ice and Fire"?
How to cut a climbing rope?
How to keep consistency across the application architecture as a team grows?
Python program for a simple calculator
Can we assume that a hash function with high collision resistance also means highly uniform distribution?
How to let other coworkers know that I don't share my coworker's political views?
How to deal with a colleague who is being aggressive?
How did NASA Langley end up with the first 737?
Writing style before Elements of Style
How do I superimpose two math symbols?
Dad jokes are fun
How was Daenerys able to legitimise this character?
Why was this character made Grand Maester?
Is there a simple example that empirical evidence is misleading?
Are there any German nonsense poems (Jabberwocky)?
Mysterious procedure calls without parameters - but no exceptions generated
Long time, sporadic 'String or Binary data would be truncated.' Wisdom would be appreciatedFinding parameter names for binding stored procedure parametersUsing concat inside a stored procedure parametersPass parameters to a procedure with SQLcmdmultiple calls to procedure optimizationHow to create SQL Stored Procedure with parameters of type List<string>Stored Procedure with Optional ParametersFrequent Remote connectivity issue for SQL Server 2008 SP3Find SSIS package which calls stored procedureStored Procedure: table-Value parameters
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I've been tracing a handful of stored procedures with EventClass RPC:Completed that are intermittently called from .Net SqlClient Data Provider without required parameters - just "exec SprocName".
If I manually call them as they appear in the trace's TextData, they generate an exception - but no exceptions are being generated in the original trace. The Error column for these "parameterless" calls does show "1 - Error," but I don't understand how the call is not generating an exception.
At first I suspected it was a glitch with profiler, that "1 - Error" caused parameters to be truncated from the TextData, but I see the same results in an extended events session.
Has anyone seen anything like this in their profiler traces or event sessions? The app is almost certainly making these calls as part of some edge-case error, but why is sql server not throwing an exception?
sql-server stored-procedures profiler parameter trace
edited 4 hours ago
MDCCL
6,90331846
asked 6 hours ago
KitKit
261
New contributor
Kit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I've been tracing a handful of stored procedures with EventClass RPC:Completed that are intermittently called from .Net SqlClient Data Provider without required parameters - just "exec SprocName".
If I manually call them as they appear in the trace's TextData, they generate an exception - but no exceptions are being generated in the original trace. The Error column for these "parameterless" calls does show "1 - Error," but I don't understand how the call is not generating an exception.
At first I suspected it was a glitch with profiler, that "1 - Error" caused parameters to be truncated from the TextData, but I see the same results in an extended events session.
Has anyone seen anything like this in their profiler traces or event sessions? The app is almost certainly making these calls as part of some edge-case error, but why is sql server not throwing an exception?
sql-server stored-procedures profiler parameter trace
edited 4 hours ago
MDCCL
6,90331846
asked 6 hours ago
KitKit
261
New contributor
Kit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I've been tracing a handful of stored procedures with EventClass RPC:Completed that are intermittently called from .Net SqlClient Data Provider without required parameters - just "exec SprocName".
If I manually call them as they appear in the trace's TextData, they generate an exception - but no exceptions are being generated in the original trace. The Error column for these "parameterless" calls does show "1 - Error," but I don't understand how the call is not generating an exception.
At first I suspected it was a glitch with profiler, that "1 - Error" caused parameters to be truncated from the TextData, but I see the same results in an extended events session.
Has anyone seen anything like this in their profiler traces or event sessions? The app is almost certainly making these calls as part of some edge-case error, but why is sql server not throwing an exception?
sql-server stored-procedures profiler parameter trace
edited 4 hours ago
MDCCL
6,90331846
asked 6 hours ago
KitKit
261
New contributor
Kit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I've been tracing a handful of stored procedures with EventClass RPC:Completed that are intermittently called from .Net SqlClient Data Provider without required parameters - just "exec SprocName".
If I manually call them as they appear in the trace's TextData, they generate an exception - but no exceptions are being generated in the original trace. The Error column for these "parameterless" calls does show "1 - Error," but I don't understand how the call is not generating an exception.
At first I suspected it was a glitch with profiler, that "1 - Error" caused parameters to be truncated from the TextData, but I see the same results in an extended events session.
Has anyone seen anything like this in their profiler traces or event sessions? The app is almost certainly making these calls as part of some edge-case error, but why is sql server not throwing an exception?
sql-server stored-procedures profiler parameter trace
sql-server stored-procedures profiler parameter trace
edited 4 hours ago
MDCCL
6,90331846
asked 6 hours ago
KitKit
261
New contributor
Kit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 4 hours ago
MDCCL
6,90331846
asked 6 hours ago
KitKit
261
New contributor
Kit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 4 hours ago
MDCCL
6,90331846
edited 4 hours ago
MDCCL
6,90331846
edited 4 hours ago
MDCCL
6,90331846
6,90331846
asked 6 hours ago
KitKit
261
New contributor
Kit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
KitKit
261
asked 6 hours ago
KitKit
261
261
New contributor
Kit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Kit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
SET PARSEONLY ON will do this. FMTONLY will generate an error.
EG:
USE [AdventureWorks]
GO
set parseonly on
go
exec [uspGetBillOfMaterials]
go
set parseonly off
answered 5 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
ParseOnly is really the only possibility I see. Unfortunately I haven't been able to capture in a trace where parseonly is being set. For direct SSMS calls I can capture it with SQL: Batch Starting, but I haven't been able to catch a single instance of it being set from an RPC. Perhaps it's in an event I'm not capturing.
– Kit
4 hours ago
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Kit is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f238811%2fmysterious-procedure-calls-without-parameters-but-no-exceptions-generated%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
SET PARSEONLY ON will do this. FMTONLY will generate an error.
EG:
USE [AdventureWorks]
GO
set parseonly on
go
exec [uspGetBillOfMaterials]
go
set parseonly off
answered 5 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
ParseOnly is really the only possibility I see. Unfortunately I haven't been able to capture in a trace where parseonly is being set. For direct SSMS calls I can capture it with SQL: Batch Starting, but I haven't been able to catch a single instance of it being set from an RPC. Perhaps it's in an event I'm not capturing.
– Kit
4 hours ago
add a comment |
SET PARSEONLY ON will do this. FMTONLY will generate an error.
EG:
USE [AdventureWorks]
GO
set parseonly on
go
exec [uspGetBillOfMaterials]
go
set parseonly off
answered 5 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
ParseOnly is really the only possibility I see. Unfortunately I haven't been able to capture in a trace where parseonly is being set. For direct SSMS calls I can capture it with SQL: Batch Starting, but I haven't been able to catch a single instance of it being set from an RPC. Perhaps it's in an event I'm not capturing.
– Kit
4 hours ago
add a comment |
SET PARSEONLY ON will do this. FMTONLY will generate an error.
EG:
USE [AdventureWorks]
GO
set parseonly on
go
exec [uspGetBillOfMaterials]
go
set parseonly off
answered 5 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
SET PARSEONLY ON will do this. FMTONLY will generate an error.
EG:
USE [AdventureWorks]
GO
set parseonly on
go
exec [uspGetBillOfMaterials]
go
set parseonly off
answered 5 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
answered 5 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
answered 5 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
answered 5 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
13.5k937
ParseOnly is really the only possibility I see. Unfortunately I haven't been able to capture in a trace where parseonly is being set. For direct SSMS calls I can capture it with SQL: Batch Starting, but I haven't been able to catch a single instance of it being set from an RPC. Perhaps it's in an event I'm not capturing.
– Kit
4 hours ago
add a comment |
ParseOnly is really the only possibility I see. Unfortunately I haven't been able to capture in a trace where parseonly is being set. For direct SSMS calls I can capture it with SQL: Batch Starting, but I haven't been able to catch a single instance of it being set from an RPC. Perhaps it's in an event I'm not capturing.
– Kit
4 hours ago
ParseOnly is really the only possibility I see. Unfortunately I haven't been able to capture in a trace where parseonly is being set. For direct SSMS calls I can capture it with SQL: Batch Starting, but I haven't been able to catch a single instance of it being set from an RPC. Perhaps it's in an event I'm not capturing.
– Kit
4 hours ago
ParseOnly is really the only possibility I see. Unfortunately I haven't been able to capture in a trace where parseonly is being set. For direct SSMS calls I can capture it with SQL: Batch Starting, but I haven't been able to catch a single instance of it being set from an RPC. Perhaps it's in an event I'm not capturing.
– Kit
4 hours ago
add a comment |
Kit is a new contributor. Be nice, and check out our Code of Conduct.
Kit is a new contributor. Be nice, and check out our Code of Conduct.
Kit is a new contributor. Be nice, and check out our Code of Conduct.
Kit is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f238811%2fmysterious-procedure-calls-without-parameters-but-no-exceptions-generated%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
