Question
I have big stored procedure on sql server 2012 it compiled success when create it
when execute it by give it parameters
exec stored procedure parameter
it give me error
but problem i cannot know this error exist on which line
so that i need any thing tell me about error on which line
my error show when execute stored procedure and cannot understand it
Msg 121, Level 15, State 1, Line 1
i need message error as error exist on line number as example 45
because i work on stored procedure may be reach to 300 lines
so that my question what this mean
Msg 121, Level 15, State 1, Line 1
What I have tried:
exec storedprocedure paramtername
cannot give me error on which line
it give me error
Msg 121, Level 15, State 1, Line 1