|
...when I want to just become a monk.
Dealing with an elephant SP. Debugger in SSMS doesn't work. The whole logic of the SP should be in the DSM 5[^] as a definition of insantity.
I just want to run away screaming and never come back. 
|
|
|
|
|
Quote: I just want to run away screaming
Do not do that! I have tried it and it does not work! 
|
|
|
|
|
you probably forgot to do it nude... that's why it didn't work 
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
In the nude?  Do you want all people in the street to start screaming in horror?
|
|
|
|
|
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Nah, but you were the one complaining it didn't work the first time.
Well, now you've got the knowledge. Use it as you please!
|
|
|
|
|
Just do what everyone else does....post in QA; "How to convert this to LINQ?"
|
|
|
|
|
Yeah, I've walked in to more than one place where the had their sprocs loaded with business logic (some > 2000 lines in a single SP). This always made me cringe.
Oh, and the DSM 5 comment...
“The palest ink is better than the best memory.” - Chinese Proverb
|
|
|
|
|
Maybe you should consider re-tiring?
(Winter is soon over, and I am certainly planning to re-tire my car to summer tires again.)
|
|
|
|
|
|
I don't think it has ever worked, I know I have never used it and I used to love SPs, printed variables have always been my debug tool in SSMS.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Mycroft Holmes wrote: printed variables have always been my debug tool in XXXX
 there are sometimes when they are the easiest way to get relevant information and many times when they are a really good additional help
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Mycroft Holmes wrote: I don't think it has ever worked
Amazingly, Visual Studio (I'm using 2017, I've heard complaints that it doesn't work on 2019) was able to debug the SP. Yay, found the issue in 60 seconds.
|
|
|
|
|
|
Jörgen Andersson wrote: To use the debugger you need to be logged in with a SysAdmin account.
Yup, and this is a local instance of SQL Express, so theoretically, no firewall should be involved, or so I would think.
|
|
|
|
|
Stranger things have happened.
I'm not sure how well the Sql server team cooperates with the Os team.
They also seem to have a lot of technical debt.
|
|
|
|
|
Marc Clifton wrote: when I want to just become a monk
or get some old monk: Old Monk - Wikipedia
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
Do people on Twitter tell me I'm lost because I don't follow them?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
No, but they won't follow you either.
Such is social media - a circle of people following other people, spinning rapidly but getting nowhere, and no one is actually leading.
|
|
|
|
|
OriginalGriff wrote: Do people on Twitter tell me I'm lost because I don't follow them?
Retweeted.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
|
Maybe if you had a pipe they would follow you.
Monday starts Diarrhea awareness week, runs until Friday!
JaxCoder.com
|
|
|
|
|
Better than being told to get lost, I suppose...
|
|
|
|
|
Do they say you are "found" if you do follow them? That would just be wrong.
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
You lost me there.
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
