Mysterious procedure calls without parameters - but no exceptions generatedLong time, sporadic 'String or...
Manager questioning my time estimates for a project
Why does Bran want to find Drogon?
Why isn't 'chemically-strengthened glass' made with potassium carbonate to begin with?
Are there any German nonsense poems (Jabberwocky)?
I know that there is a preselected candidate for a position to be filled at my department. What should I do?
USPS Back Room - Trespassing?
Gravitational effects of a single human body on the motion of planets
What Armor Optimization applies to a Mithral full plate?
What are the conditions for RAA?
Is the Unsullied name meant to be ironic? How did it come to be?
What does kpsewhich stand for?
Why did the person in charge of a principality not just declare themself king?
便利な工具 what does な means
Why did Jon Snow do this immoral act if he is so honorable?
Security vulnerabilities of POST over SSL
The art of clickbait captions
Parallel fifths in the orchestra
Must a warlock replace spells with new spells of exactly their Pact Magic spell slot level?
Dealing with spaghetti codebase, manager asks for things I can't deliver
Time complexity of an algorithm: Is it important to state the base of the logarithm?
What is the use case for non-breathable waterproof pants?
Natural Armour and Weapons
Why is the Eisenstein ideal paper so great?
Is there any relationship between frequency of signal and distance it travels?
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 8 hours ago
MDCCL
6,90331846
asked 9 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 8 hours ago
MDCCL
6,90331846
asked 9 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 8 hours ago
MDCCL
6,90331846
asked 9 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 8 hours ago
MDCCL
6,90331846
asked 9 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 8 hours ago
MDCCL
6,90331846
asked 9 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 8 hours ago
MDCCL
6,90331846
edited 8 hours ago
MDCCL
6,90331846
edited 8 hours ago
MDCCL
6,90331846
6,90331846
asked 9 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 9 hours ago
KitKit
261
asked 9 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 9 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
7 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 9 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
7 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 9 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
7 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 9 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 9 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
answered 9 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
answered 9 hours ago
David Browne - MicrosoftDavid Browne - Microsoft
13.5k937
answered 9 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
7 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
7 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
7 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
7 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
