Interpreting SP line numbers in TRACE 1204 output?

All:

I'm troubleshooting a deadlock between SPs, and I'm seeing information in 
the 1204 log output that makes no sense:

.... spid4        SPID: 61 ECID: 0 Statement Type: SELECT Line #: 53
.... spid4        Input Buf: RPC Event: le_insert_customer_$sp;1

Line 53 of that SP is up in the declarations of the SP parameters. How can 
there be a deadlock at that point?

For the purposes of interpreting 1204 output, are there any special rules 
for determining which line number in the SP the log is actually referring 
to? Do you start counting from the CREATE PROC line? Or the first line after 
the parameter declarations? Or what?

-- 
John Hardin KA7OHZ
Senior Applications Developer, BI Specialist
EPICOR Retail
  web: http://www.epicor.com
voice: (425) 245-1800
  fax: (425) 670-1810
email: <jhardin@epicor.com>
20818 44th Ave. W., Suite 270
Lynnwood, WA 98036 USA
Worldwide Headquarters 18200 Von Karman, Suite 1000, Irvine CA 92612 USA
------------------------------------------------------------------------
 The first time I saw a bagpipe, I thought the player was torturing an
 octopus. I was amazed they could scream so loudly.
------------------------------------------------------------------------ 

0
John
3/29/2010 5:13:55 PM
sqlserver.server 1327 articles. 0 followers. Follow

0 Replies
692 Views

Similar Articles

[PageSpeed] 29

Reply:

Similar Artilces:

Payroll Batch Number
Is it possible to obtain the batch number of a transaction after it has been posted? I have been asked to create a report for our payroll department that lists the batch number in addition to the transaction detail that is contained in UPR30300. Thank you, Jeff Majchrzak No, the batch number is not available for reporting. -- Charles Allen, MVP "Jeff Majchrzak" wrote: > Is it possible to obtain the batch number of a transaction after it has been > posted? I have been asked to create a report for our payroll department that > lists the bat...

chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the number of the column I want to chart (these numbers are listed as labels in cells A2:R2). I can't figure out how to translate the number in S4 into the corresponding column letter. For example, if S4 contains "3", the chart title should be =$C$2. I think working with absolute references, R1C1, might be easier here, but somehow what I've tried, didn't work (the entire spreadsheet is based on relative addresses (A1). z.entropic in a cell (Z100) put =index(A2:G2,1,S4,1) Change G2 to whatev...

Auto formatting features: How do I align page numbers in publicati
I've got a problem with my publication. I can't align even page numbers to the left without automatic moving the odd numbers to the left as well? Can someone help me? Cissy99 wrote: > I've got a problem with my publication. I can't align even page numbers to > the left without automatic moving the odd numbers to the left as well? Can > someone help me? You need to create a two-page master rather than a one-page master. What version of Publisher are you running? -- Ed Bennett - MVP Microsoft Publisher http://ed.mvps.org ...

SP in IN clause
Is it possible to use a stored procedure inside an IN clause? For example below, the stored proc returns a single column of TimeID values. SELECT TimeID FROM dbo.Timesheets WHERE (TimeID IN(EXEC mc_selDuplicateTimesheets)) Or is there another workaround? Thanks. -- David You can use a table to store the SP output and then use the table in the query: CREATE TABLE #Dups (TimeId INT); INSERT INTO #Dups (TimeId) EXEC mc_selDuplicateTimesheets; SELECT TimeID FROM dbo.Timesheets WHERE TimeID IN (SELECT TimeId FROM #Dups); -- Plamen Ratchev http://www.SQLStudio.com...

z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and bars in an Excel 2007 chart, such as drop lines, high-low lines, up/ down bars, and error bars? I observed that when I add drop lines to an Excel 2007 chart, they appear in front of the underlying data -- in my case, the underlying data is displayed as a plotted area. I want the plotted area to be fully visible with no lines over it. I would like to send the drop lines to the back and keep the plotted area in the front, but there is no option to do this. So, is there a procedure for adjusting the z-order of drop...

How do I break URL address over two lines?
I am trying to enter website addresses into footnotes and Word automatically forces the footnote onto a separate line. I need to conform to certain aditing requirements and want the url to start right after the citation and continue on to however many lines are necessary, but not leave a gap because it starts the url on a separate line in the footnote. Help please. In the edit hyperlink dialog, put the URI in both the Address and Text-to- display boxes. That way you can use a space or linebreak to wrap the display text to the next line without affecting the hyperlink ability. Hyp...

Only one line in Money invoice
I have been using Money 2007 Home & Business to create and print invoices. This program has run with no problems for some time. However, just recently, it will only allow one item to print on the invoice. I can enter more than one item, and the invoice entry will show the additional items, but when printed only one item will show up. I have tried backing up my Money file to a spare disk, deleting the program and the associated mny and mbf files from the computer, reinstalling the program and reloading the backup. The same fault immediately occurs. Strangely, I have now installed the sam...

Numbering Recurring Items #2
Hey all, Is it possible to number recurring items such as tasks and appointments? I have several recurring appointments for lectures, and would like to show them as "Lecture 1" in week/occurence 01, "Lecture 2" in week/occurance 2, etc. Thanks, Murdoc -- Murdoc ## ------------------------ "The journey of 1000 miles begins with a broken fan belt and a leaky tyre." "Duct tape is like The Force. It has a light side and a dark side, and it holds the universe together." "If the facts don't fit the theory, change the facts." -Albert Einstein &...

Excel devides every number by 100
Even when I open a brand new file. I input a number (ie 5) and get 0.05 back. I have tried doing everything in cell format etc.. anyone have an idea? it is very annoying and adding loads of work to my project. thanks "=?Utf-8?B?a2luZ3M=?=" <kings@discussions.microsoft.com> wrote in news:48A39EFC-2D09-420F-B2DF-6EF5C0DB6109@microsoft.com: > Even when I open a brand new file. I input a number (ie 5) > and get 0.05 back. I have tried doing everything in cell > format etc.. anyone have an idea? it is very annoying and > adding loads of work to my project. > ...

SP 1 & 2 Updates
I noticed that when I installed the SP 1 & 2 Updates, I could no longer get .zip, .doc, .htm, .exe attachments and anything like that (.jpg and .gif are no problem). Is there a way to enable attachments of other types to come through? I would like to install the Updates, but need to be able to receive attachments. Thanks for your help. ...

what is straight line depreciation and double line depreciation?
See http://en.wikipedia.org/wiki/Depreciation In article <928DC52C-D390-45C6-9847-693648A1A5DA@microsoft.com>, MISSY <MISSY@discussions.microsoft.com> wrote: "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message news:jemcgimpsey-F62312.22355624092007@msnews.microsoft.com... > See > > http://en.wikipedia.org/wiki/Depreciation > Quite a good article for wikipedia, but it misses one very important point. The original purpose of charging depreciation to the P&L was to build up a reserve in order to replace the asset when it became obsol...

Getting same number to appear over and again
Hi. I'm trying to change the E's I have entered in a column to 1's. However, in lieu of changing them one by one, I would like to do them all in one fell swoop. Any suggestions? John Hi John You could use find and replace. Select all of your data. Goto Edit>Find Find what:- E Replace with:- 1 HTH Martin John Do NOT multipost. See your answer in Excel group. And do a google search for newsgroup etiquette!! John Do NOT multipost. See your answer in Excel group. And do a google search for newsgroup etiquette!! John Do NOT multipost. See your answer in Excel ...

page numbering
I want to change the way the date appears in the footer and header. Currently the date is day/month/year. I want month/day/year. setting the date to a particular format is easy in a cell. How do I set the date format in the header and footer? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ jamessem, you could use a macro like this to do it Sub test() With ActiveSheet.PageSetup .LeftFooter = Format(Date, "mmmm dd, yyyy") End With End Sub ...

Office 2004 SP 11.1.0 installation problems
I'm trying to update Office 2004 on my brand new iBook. I installed Office 2004 from the CD without incident. Then I downloaded SP 11.1.1.0 and 11.1.0 (which according to the MS website is to be installed 1st.) When I try to install, I received a message, "An error prevented the update from completing 11002:2,-14" The "Read Me" file indicates several potential explainatins/solutions none of whice are relevant except for uninstalling Office and then reinstalling it. I tried dragging the Office folder to the trash and reinstalled and am having the same problem. I've t...

Open Continuous form with a few lines showing
Hi I have successfully implemented a continuous form to open at a new line with RunCommand acCmdRecordsGoToNew in the Load Event However, you have to manually scroll a little to see a few of the previous records. It would be nice to see up to 5 of these previous lines on Opening the form Is there a way to modify this code to do that? Thanks Neil Change the form's underlying record source to a Top 5 query. In a query's design view, right click in a blank area, and choose properties. Set the Top Values to 5, then adjust your criteria and order by clause to ret...

Bug in Grid Lines in CListCtrl Report View
Hi, This thing is again annoying me! whenever I display the grid lines using LVS_EX_GRIDLINES , there are problems when scrolling the CListCtrl at once , the grid lines seem to loose their position and thus generating a blurred view or sometimes just disappear temporarily. Have anyone else faced the same thing ? Thanks >whenever I display the grid lines using LVS_EX_GRIDLINES , there are >problems when scrolling the CListCtrl at once , the grid lines seem to loose >their position and thus generating a blurred view or sometimes just disappear > temporarily...

Repeat statements "x" number of times...
Hi All, I have the following code at the end of a long macro: Columns("D:D").Find(What:="total").Select ActiveCell.Offset(0, 4).Range("A1").Select ActiveCell.FormulaR1C1 = "=Sum(RC[-1]-RC[-2])" ActiveCell.NumberFormat = "0.00" ActiveCell.Font.Bold = True With ActiveCell.Interior .ColorIndex = 6 End With What I am doing is when the word "total" appears, it will go to the cell 4 columns to the right, and then do a formula and format the cell. Question: How can I get this to repeat itself for eac...

XslTransform.Transform, invalid character output to Response.OutputStream
When I use the XslTransform.Transform method to write to the HttpRequest.OutputStream The first byte of the output is always an invalid character, looks like an ascii zero or some other non-printable ascii char. The problem is that it messes up my display. Here is the code: .... Response.Write("<span>some text</span>"); XmlTextReader reader = new XmlTextReader(xslFile); XslTransform xsl = new XslTransform(); xsl.Load(reader, resolver, evidence); xsl.Transform(xmlDoc, args, Request.OutputStream, resolver); HTML Output: <span>some text</span>"inval...

Output to macro to sharepoint
Hi all i need help please, Using Access 2000 and up I have an update macro that is doing update to tables and produces a report that normally gets printed out. Now i need to stop printing reports and distribute them electronically. My idea is to have them in SNapshot format and push them to a SharePoint library. I have tried this several times and get 'The report snapshot was not created because you don't have enough free disk space for temporary work files'. It then goes on to tell me to empty my recycle bin. I have done a disk clean and nothing changed. Is it that i can't sa...

Scatterplot with a best-fit line
How do i create one scatterplot with three separate data sets and a best-fit line to go with each set? Make an XY chart with the first set of X-Y values. Copy the second set of X-Y values, select the chart and use Edit menu > Paste Special, and add the data as a new series, categories in first column (row). Repeat for the third set of X-Y values. Add the trendline to each series by selecting the series, right clicking, and choosing Add Trendline. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "neally" <neall...

sort special text/numbers in format with many dots
Hi I need your help with sorting in Excel! I have mani Text fields with numbers into it. As example: 1 5.1 1.2 10.2.1 1.2.3 2 2.1.5 3 3.2.1.1 3.3.1.1.1 And it should sorted like this 1 1.2 1.2.3 2 2.1.5 3 3.2.1.1 3.3.1.1.1 5.1 10.2.1 How can I sort this like numbers? My problem is, that not all Numbers have the same format as x.x.x.x! And I can't change this Text-Fields to Numbers, because 10.6.1 looks the like 37052 :-( Any suggestions? Thx Marco Hi With your data in column A, insert a blank column at B. In B1 enter =IF(ISNUMBER(FIND(".",A1)),LEFT(A1,FIND(".&q...

revision lines on Word
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I need to show when text is revised by inserting a line in the left margin. This works ok on text, and has worked with tables and ToC in past versions (2004 for Mac). Now in the new version it causes formatting chaos. <br> I draw a line in the left margin of a page with a table and when the mouse is released the line a) disappears, or b) jumps up to the previous page, or c) jumps over into the table and displaces the contents downward off the page. <br> I am not using the Track Changes feature. &l...

How do you change data values by dragging graph lines in excel 07?
Firstly, please ask your question in the body of the message, not the subject line. Secondly, you don't in Excel 2007; that was one of the "improvements" they put in. Most experts prefer the charting facilities in Excel 2003 over those in Excel 2007. -- David Biddulph "Mannymeister" <Mannymeister@discussions.microsoft.com> wrote in message news:3616E56A-A8BF-44D4-9E38-8746B39DCD7E@microsoft.com... > ...

How do I format cells to a specific number of digits?
I am trying to format a column so I can enter 5 digits only. It has between 5 and 7 digit numbers in it right now and I need to delete the remaining ones. It is about 350 numbers, so it would be a lot of work to go into each cell and delete the remaning numbers. Is therea way I can format the whole column to allow 5 digits? The same happened with letters. I had codes in it that consisted of numbers and letters and the client only wants the first two letters to remain. How can it be formatted so only 2 characters are allowed to keep me from having to enter each cell separately? Hi form...

how do I enter more than one line in the same Excel Cell by using.
I want to have more than one line of text in the same Excel Cell without using the wrap text format option. For example, I want to put an entire address in the Cell by typing in the name of the person, then hit enter, type the steet address, then hit enter, then type in the city, state, and zip. Use alt-enter to put in a line break. "vsimmons" wrote: > I want to have more than one line of text in the same Excel Cell without > using the wrap text format option. For example, I want to put an entire > address in the Cell by typing in the name of the person, then hit en...