
īelow is the sample error log after deadlock occured. But I am not able to interpret the error logs after deadlock occurs on it. I have enabled the deadlock trace flag 1222 on my server. We actually have a tip on doing just that: We love this website because of it's contents and this is really not TIPS at all.īack To Top - thanks for pointint that out.
#DISPLAY LINE NUMBERS IN WORD HOW TO#
Could next MSSQL TIPS be how to turn on your computer? Are you kidding me? I am not saying to the writer. Thanks again for your feedback and we'll try to balance the tip topics the best we can. Some things that may be very obvious to some are not so obvious to others such as this tip. The thing to keep in mind is that the site has various levels of people using SQL Server. You a life saver!!!!īack To Top - thanks for your feedback. Wow.this really helps! I am new to SQL Server. We were all beginners once and I see nothing wrong with trying to help them at. Thanks for pointing out how to enable this.īack To Top There is room for tips that are targetted at the absolute beginners as well. I had seen Line Numbers display in SSMS while attending few webcasts and always wondered how to get this feature enabled as this is so useful in day-to-day work. Wow! Thanks MSSQLTips for this quick tip. we were also newbies at one point.Īnother cool thing in SSMS around line numbers is if you double-click an error message in the results pane, it usually takes you to the line that has the error! Yeah, you never know who's reading a tip, so it's good to include newbies where possible. Please send me a direct email ( I would like to hear your feedback. In that case, double-clicking the error message is really the only way to find the offending line. That is, if the error message complains about line 17, it is not really line 17, it is the 17th line withing the scipt. If you have more than one script in a query window, which I do often enough, then it is frustrating to find the the error message gives you a line number *within the specific script*. If you did not need it, fine, but that does not mean that no one else did. Zen: Yes, it was a tip, and it was useful to me. If you add text to the line containing your equation, Word 2007 will automatically change it to an inline equation. But I DO know how to turn my computer on, so no need for a tip on that. Display equations in Word 2007 cannot have any other text on the same line. Also, handy to know that double-clicking the error takes me right to the error. I'm not an absolute beginner, but I'd have spent way too much time looking for this myself. A quick google searched showed this article.
#DISPLAY LINE NUMBERS IN WORD CODE#
Thanks for this tip! I'm not new to SSMS, but I haven't written much SQL code in it - done that in external tools. Saturday, Octo1:54:26 AM - Arnor Baldvinsson Thanks for sharing and keep the basic reminders coming. Then when I need it, I can't remember how to get to it. If I do not consistently use a tool, I will forget about it. I like having some basic tips and they are not only for beginners. Well, I'm a "seasoned beginner" and I did not know how to turn on the line count, nor about the double-click error jump. I Love MSSQLTips as they bringing something new every day for every learner.

Also huge thanks to Fatherjack for his tip as well!

Wednesday, Janu1:02:36 AM - vikrant thakkar Thanks for the very easy too follow explanation!Īll you have to do to find an error by line number is double click on the error message and SSMS takes you directly to it.

In SSMS v17.1 which I have installed, the Line Number option is found in a different place Options | Text Editor | Transact-SQL | Settings You can also check out previously reviewed guides on Auto-recover Information Setting & View two Documents side by side.Thanks for the effort of step by step explaining. Upon clicking you will notice, that respective info will start showing up in the status bar. For this start enabling these options by clicking them. Now we want to show Word Count, Spelling and Grammar Check, Caps Lock (ON/OFF), Line Number, Page Number, and Macro Recording (ON/OFF). To start off, we want to show different info in the status bar, for this right-click the bar, and start enabling/disabling the options as shown in the screen shot below. Launch Word 2010, to customize status bar being present at the bottom of the window. In this post we will be showing some important info in Status Bar. Word provides an option to customize Status bar, so you can add, delete information from it. It describes the status of document, and give a quick look on word count, running macros, number of line being edited, etc. The Status bar is at the bottom of the Word document window and provides useful information from the Word app.
