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
Colloquialism for “see you later”
Overlapping String-Blocks
What setting controls moving the cursor on the command line?
How is water heavier than petrol, even though its molecular weight is less than petrol?
Wooden cooking layout
Thread Pool C++ Implementation
What ways have you found to get edits from non-LaTeX users?
Why didn't Voldemort recognize that Dumbledore was affected by his curse?
Winning Strategy for the Magician and his Apprentice
Is an entry level DSLR going to shoot nice portrait pictures?
How come the nude protesters were not arrested?
How do I prevent employees from either switching to competitors or opening their own business?
Check if three arrays contains the same element
How to hide an urban landmark?
Teaching a class likely meant to inflate the GPA of student athletes
Geopandas and QGIS Calulating Different Polygon Area Values?
Mathematically, why does mass matrix / load vector lumping work?
How is John Wick 3 a 15 certificate?
Implement Own Vector Class in C++
A IP can traceroute to it, but can not ping
How can I make some of my chapters "come to life"?
Is it legal for a bar bouncer to confiscate a fake ID
What is the actual quality of machine translations?
Is it possible to have the age of the universe be unknown?
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 May 22 at 19:28
MDCCL
7,00831847
asked May 22 at 17:44
KitKit
332
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 May 22 at 19:28
MDCCL
7,00831847
asked May 22 at 17:44
KitKit
332
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 May 22 at 19:28
MDCCL
7,00831847
asked May 22 at 17:44
KitKit
332
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 May 22 at 19:28
MDCCL
7,00831847
asked May 22 at 17:44
KitKit
332
edited May 22 at 19:28
MDCCL
7,00831847
asked May 22 at 17:44
KitKit
332
edited May 22 at 19:28
MDCCL
7,00831847
edited May 22 at 19:28
MDCCL
7,00831847
edited May 22 at 19:28
MDCCL
7,00831847
7,00831847
asked May 22 at 17:44
KitKit
332
asked May 22 at 17:44
KitKit
332
asked May 22 at 17:44
KitKit
332
332
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 May 22 at 18:13
David Browne - MicrosoftDavid Browne - Microsoft
13.6k1937
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
May 22 at 19:42
Try setting up Extended event and capture all calls from certain hostname or user (or SPID, if you know it).
– Zikato
May 23 at 6:33
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
);
);
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 May 22 at 18:13
David Browne - MicrosoftDavid Browne - Microsoft
13.6k1937
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
May 22 at 19:42
Try setting up Extended event and capture all calls from certain hostname or user (or SPID, if you know it).
– Zikato
May 23 at 6:33
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 May 22 at 18:13
David Browne - MicrosoftDavid Browne - Microsoft
13.6k1937
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
May 22 at 19:42
Try setting up Extended event and capture all calls from certain hostname or user (or SPID, if you know it).
– Zikato
May 23 at 6:33
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 May 22 at 18:13
David Browne - MicrosoftDavid Browne - Microsoft
13.6k1937
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 May 22 at 18:13
David Browne - MicrosoftDavid Browne - Microsoft
13.6k1937
answered May 22 at 18:13
David Browne - MicrosoftDavid Browne - Microsoft
13.6k1937
answered May 22 at 18:13
David Browne - MicrosoftDavid Browne - Microsoft
13.6k1937
answered May 22 at 18:13
David Browne - MicrosoftDavid Browne - Microsoft
13.6k1937
13.6k1937
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
May 22 at 19:42
Try setting up Extended event and capture all calls from certain hostname or user (or SPID, if you know it).
– Zikato
May 23 at 6:33
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
May 22 at 19:42
Try setting up Extended event and capture all calls from certain hostname or user (or SPID, if you know it).
– Zikato
May 23 at 6:33
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
May 22 at 19:42
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
May 22 at 19:42
Try setting up Extended event and capture all calls from certain hostname or user (or SPID, if you know it).
– Zikato
May 23 at 6:33
Try setting up Extended event and capture all calls from certain hostname or user (or SPID, if you know it).
– Zikato
May 23 at 6:33
add a comment |
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
