I have hundreds of stored procedures in my SQL Server 2012 database.  From my c# code, I am calling one of the stored procedures which in turn calls another stored procedure and so on.  There is a failure in stored procedure execution. I need to debug it. For that I need to know what are the values which are sent as parameter when calling stored procedure inside another stored procedure .  I cannot alter the stored procedure, is there any way to Watch and StackTrace stored procedures?  Yes, I am using Visual Studio 2010
What are good methodologies for creating sprocs that reduce the pain of debugging? And what tools are out there for debugging stored procedures?  Perhaps most importantly, what are indications to look out for that errors are happening in a sproc and not in the code? I hope I'm not all over the board too terribly bad here. Votes for answers to any of the above. Thanks.  For what it's worth, I work in a .NET environment, SQL servers.
Consider the following sentences:        I'll move to the south by then probably.   I'll probably move to the south by then.   I'll move to the south probably by then.      Which of the three is correct. In my opinion, the third one is wrong. First two are correct with a small difference in their meaning.  First one makes my probability refer to the time when I'll be moving and the second one tells that there is still a chance that I might not move.  Am I correct? Are there any non-decreasing securities on the stock market? Are there any securities traded on the stock market (i.e. ETPs) that never decrease in value?    As an aside (in case anyone mentions bonds):  I'm aware there's ETFs for AAA-rated government bonds, but even these dip significantly.  For example, the  has dipped by 9% in a 85-day period before (21/08/2016 to 13/11/2016). How to power a button's LED within a guitar? I'm working on a guitar, and the plan is to use three latching push buttons so that each pickup can be turned on and off individually. I'm fairly confident that the following diagram should work for that (Feel free to correct me)   The buttons I want to use are , which have a built-in LED when turns on when the button is pressed.   Which brings me to my question: Is there a way to power the LED? If I introduce a 9volt into the wiring, wouldn't that cause problems with the guitar's standard electronics? Which graphic file formats are supported by browsers? Prove $g$ is a generator if $g^q=1 \pmod p$ Let $p$ be an odd prime and let $q=\frac{p-1}{2}$. If $g^q=-1\pmod p$ and $q$ is a prime, show that $g$ is a primitive root mod $p$.  I want to show $\{g,g^1,...,g^{p-1}\}=\{1,2,...p-1\}$. I argue by contradiction that if there're $x,y\in \{1,2,...p-1\},x&lt;y,g^x=g^y\pmod p$. Then $g^{y-x}=1\pmod p$. I don't know how to use the fact that $q$ is prime to lead to a contradiction. How to calculate square root or cube root? I was reading Richard Feynman biography when I read that one time he was able to calculate the  cube root of large number in his brain by just using simple facts of everyday life. So my question is there a way to calculate square root or cube root by using just a pen a paper, I mean a systematic way not by trial and error. I have seen many examples of how to render sprites from a spritesheet but I havent grasped why it is the most common way of dealing with sprites in 2d games.  I have started out with 2d sprite rendering in the few demo applications I've made by dealing with each animation frame for any given sprite type as its own texture - and this collection of textures is stored in a dictionary. This seems to work for me, and suits my workflow pretty well, as I tend to make my animations as gif/mng files and then extract the frames to individual pngs.  Is there a noticeable performance advantage to rendering from a single sheet rather than from individual textures? With modern hardware that is capable of drawing millions of polygons to the screen a hundred times a second, does it even matter for my 2d games which just deal with a few dozen 50x100px rectangles?  The implementation details of loading a texture into graphics memory and displaying it in XNA seems pretty abstracted. All I know is that textures are bound to the graphics device when they are loaded, then during the game loop, the textures get rendered in batches. So it's not clear to me whether my choice affects performance.  I suspect that there are some very good reasons most 2d game developers seem to be using them, I just don't understand why. What is the procedure followed by game programmers for saving and resuming game state? like files/mappings. I want to save it for tower defense game and I am using unity3D game engine. JSON and escaped double quote I'm currently making a callout to a 3rd party vendor and I'm getting a huge response. What is currently messing me up is this section:   "MessageSeq":13,"Description":"config file: config-qa1.txt\"","MessageTS":"2014-02-17T14:46:58","MessageLevel":4,"IsSystemMessage":false   As you can see here, the portion at the end of the Description value is ended with backslash double quote. If I attempt to parse this via the JSONParser I get an exception. Does anyone have an recommendations on how to resolve this?  Exception Message:  System.JSONException: Unexpected character ('"' (code 34)): was expecting comma to separate OBJECT entries at [line:1, column:3699]  Updated with sample Code   public class ResponseWrapper{     // fields from JSON to auto map     public Integer messageSeq;     public String Description;     public String messageTS;     public Integer messageLevel;     public Boolean isSystemMessage;     // parsing fields     private ResponseWrapper theResponse;     private JSONParser parser;      public void parse(String jsonString){         parser = JSON.createParser(jsonString);         parseJSON();     }      private void parseJSON(){            while (parser.nextToken() != null) {             if (parser.getCurrentToken() == JSONToken.START_OBJECT) {                 theResponse = (ResponseWrapper)parser.readValueAs(ResponseWrapper.class);                            }         }     } }  String responseString = '{"MessageSeq":13,"Description":"config file: config-qa1.txt\"","MessageTS":"2014-02-17T14:46:58","MessageLevel":4,"IsSystemMessage":false}'; system.debug('\n\nBEFORE\n' + responseString); ****Place code in here to test such as ReplaceALL*** ResponseWrapper parser = new ResponseWrapper(); parser.parse(responseString); How disk space is used on Android device? I have critical low storage level and can't understand what takes much of it and how that's possible that the installed applications can use 7 GB? I only use a few social media clients without any games or soft like Photoshop. Also on the second screenshot it indicates that the apps are using just 1.13 GB and so I can't understand the situation. Also what is the "Other"? How to request a random row in SQL? 15V 3A dc motor PWM frequency setting What is a suitable frequency for 15V/3A DC motor? Is there any effect on the motor when the frequency is changing? I am confused with this until now and the Internet shows a lot of theory that confuses me. Why did Littlefinger give Sansa to the Boltons? This question is about the TV show only.  In the books, Sansa is still with Littlefinger and everything that happens between Sansa and Ramsay in the show actually takes place between Ramsay and Jeyne Poole in the books.  However I don't recall why Littlefinger sends Sansa north. Apparently, in the books, it's safer to keep her traveling. So why did he do it in the show? I want to use an old drive as a secondary hard drive without reformatting. But this old hard drive contains my old Vista installation which takes up gigs of space.  I tried changing ownership and it works to some extent but I can not delete anything in Windows/System32 folder.  Is there an easy way to change permissions so I can delete everything?    The solution is to use Takeown as Wil suggested and use cacls to take full control of the files. Since cacls doesn't seem to be recursive, I fired up cygwin and ran this command to recursively change all the files:  for d in $(find directory-of-interest -type d);do   cacls $d'/*' /e /G username:F; done   where directory-of-interest is in my case /cygdrive/g/Windows and username is my username.  I had to manually run it on directories that had spaces in its name. But after all this, I can now delete the directory. Warning: it seems to me that cacls can potentially royally screw things up if improperly used. cat files with directory Is there a command to show the directory/file name when cat files?  For example: assume two files f1.txt and f2.txt are under ./tmp  ./tmp/f1.txt ./tmp/f2.txt    Then when I do cat ./tmp/*.txt, only the content of files will be shown. But how to firstly show the file name, then the content?, e.g.:   (The needed command):  ./tmp/f1.txt:    This is from f1.txt  and so on  ./tmp/f1.txt:  This is from f2.txt ...   Is there a command to do it? (There seems to be no option for 'cat' to show the file names) What's the best way to write Mathematical Equations on the Web? Standard Visitor visa refusal (Deception, V3.6(b)) and procedure for reapplying My mother acquired a criminal record in UK in 2010 when she was given a conditional discharge for 12 months and charged £85. This time while applying the on-line applications for her, I accidentally missed the criminal records column and replied "NO". The visa was refused with appeal and administrative review not allowed.  Can someone please suggest my next course of action for reapplying for a visa  It is an extremely urgent family matter, and I want the visa as early as possible. While researching I found in a blog some mention of a forwarding letter while reapplying.  Can someone please enlighten me on the entire issue? History of changes to a particular line of code in Subversion Is it possible to see the history of changes to a particular line of code in a Subversion repository?  I'd like, for instance, to be able to see when a particular statement was added or when that statement was changed, even if its line number is not the same any more. I recently got a new router, a DRL-600L Router from D-Link, and was setting up some filters to block out certain websites.  One problem I am having is blocking out addresses that use https instead of http.  For example, I'm trying to block out Facebook, because Facebook.   So far, the filter filters http://www.facebook.com perfectly fine, but for the url https://www.facebook.com, it won't block that.  How can I block those kinds of websites? I'm reading that a 50mm lens is recommended as a first prime lens for DSLR owners as it's supposed to give a 'natural' perspective, but when used on (most) DSLRs, the view is cropped, as if you were zoomed in by 1.5-1.6x, so it's more of a telephoto lens when used on a DSLR. I've also read however that the 50mm lens gives the same perspective on a DSLR and a 35mm, and shouldn't really be considered to be 'equivalent' to an 80mm lens as the crop factor isn't really a magic focal length changer.  Can someone explain how the image is different from (for example) a 50mm lens on a DSLR and an 80mm lens (assuming 1.6x crop factor) on a 35mm camera?