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
Natural Armour and Weapons
Beginner looking to learn/master musical theory and instrumental ability. Where should I begin?
What did the 'turbo' button actually do?
How to deal with a colleague who is being aggressive?
My players want to grind XP but we're using milestone advancement
Is there any relationship between frequency of signal and distance it travels?
Is it possible to remotely hack the GPS system and disable GPS service worldwide?
What is the use case for non-breathable waterproof pants?
Why are GND pads often only connected by four traces?
Grade-school elementary algebra presented in an abstract-algebra style?
Of strange atmospheres - the survivable but unbreathable
Why does Bran want to find Drogon?
Why isn't 'chemically-strengthened glass' made with potassium carbonate to begin with?
Where is Jon going?
Python program for a simple calculator
What does kpsewhich stand for?
Why do we need to chain the blocks (creating blockchain) in a permissioned blockchain?
Why do Russians almost not use verbs of possession akin to "have"?
Why did other houses not demand this?
Is it legal to meet with potential future employers in the UK, whilst visiting from the USA
Determine this limit
Can I install a back bike rack without attachment to the rear part of the frame?
Why did Jon Snow do this immoral act if he is so honorable?
Dealing with spaghetti codebase, manager asks for things I can't deliver
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 6 hours ago
MDCCL
6,90331846
asked 8 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 6 hours ago
MDCCL
6,90331846
asked 8 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 6 hours ago
MDCCL
6,90331846
asked 8 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 6 hours ago
MDCCL
6,90331846
asked 8 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 6 hours ago
MDCCL
6,90331846
asked 8 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 6 hours ago
MDCCL
6,90331846
edited 6 hours ago
MDCCL
6,90331846
edited 6 hours ago
MDCCL
6,90331846
6,90331846
asked 8 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 8 hours ago
KitKit
261
asked 8 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 7 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
6 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 7 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
6 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 7 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
6 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 7 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 7 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
answered 7 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
answered 7 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
answered 7 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
6 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
6 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
6 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
6 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
