EXEC Strangeness

Hi all,

I would be very grateful if anyone can detect the problem with the following code. I have indicated the offending line. Basically if I hardcode in @.BelegId, it runs with no problems.

Declare @.SQL VarChar(1000)
Declare @.TableName VarChar(1000)
Declare @.Result Varchar(50)
Declare @.BelegId int
Set @.BelegId=447
Set @.ObjName='s_jps.ap_gr'

if (object_id (N'tempdb..#tempt') is not null) drop table #tempt;
create table #TempT (result varchar(1000))
--SELECT @.SQL='DECLARE @.RESULT VARCHAR(1000) '

SELECT @.SQL = 'SELECT CONVERT(VARCHAR(1000),' + @.ObjName + ') FROM '
SELECT @.SQL = @.SQL + 's_jps '
***PROBLEMATIC LINE FOLLOWS: IF I HARDCODE BELEGID, NO PROBLEMS***
SELECT @.Sql= @.Sql + 'WHERE de_beleg_id=' + @.BelegId
SELECT @.sql = @.sql + ' and s_se_art_id=5'
INSERT #TempT Exec ( @.SQL )
SELECT * FROM #TempT
GO

He's a quick fix without knowing anything else about your environment...

Change Declare @.BelegId int to Declare @.BelegId varchar(5)

SQLDiva

|||SELECT @.Sql= @.Sql + 'WHERE de_beleg_id=' + convert(varchar(10), @.BelegId)|||Please take a look at sp_executesql. It is safer to use sp_executesql than concatenating strings to execute in dynamic SQL. You need to protect the code against SQL injection attacks. And you should avoid dynamic SQL in this case if it is easier to just use a static SELECT statement specifying the table name. You probably don't need a temporary table also unless you are doing some complex processing.|||Thanks for the advice. I already looked into sp_executesql but had all sorts of problems with output parameters.

And I'm afraid that the unfortunate truth is that I do have to do some complex processing.

Exec StoredProcedure in Query?

I have two stored procedures that have a common column and I need to write a query like this:

pseudo code:

Code Snippet

select * from (exec firstProcedure 'argument') T where T.ID not in (exec secondProcedure 'arg') S;

What's the proper way to do this?

It is not possible, Convert your Sp as inline table or table valued function (UDF).

Sample,

Code Snippet

Create Function firstProcedure (@.arg int)

returns table

return

(

Select id from Sysobjects

)

GO

Create Function secondProcedure (@.arg int)

returns table

return

(

Select id+10 id from Sysobjects

)

GO

Select * from firstProcedure(1) Where id not in (Select id from secondProcedure(2))

|||Another alternative is to create temp tables and use INSERT INTO ... EXEC proc syntax to load the data into two different temp tables and then to join the temp tables. My first choice is normally to do as ManiD suggested and create either a function or a view; however, there are some procedures that simply cannot be converted. If this is the case, the temp table option might work best.|||

You can also use functions OPENQUERY (if you added a linked server) or OPENROWSET.

Example:

SELECT TOP 10 *

FROM OPENROWSET('SQLOLEDB', '(local)';'my_user';'my_pwd', 'EXEC Northwind..[Ten Most Expensive Products]') as t

go

AMB

sql

Exec SQL Task: Capture return code of stored proc not working

I am just trying to capture the return code from a stored proc as follows and if I get a 1 I want the SQL Task to follow a failure(red) constrainst workflow and send a SMTP mail task warning the customer. How do I achieve the Exec SQL Task portion of this, i get a strange error message [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_SingleRow".

Using OLEDB connection, I utilize SQL: EXEC ? = dbo.CheckCatLog

EXEC SQL Task Editer settings:
RESULTSET: Single Row
PARAMETER MAPPING: User::giBatchID
DIRECTION: OUTPUT
DATATYPE: LONG
PARAMETER NAME: 0

PS-Not sure if I need my variable giBatchID which is an INT32 but I thought it is a good idea to feed the output into here just in case there is no way that the EXEC SQL TASK can chose the failure constrainst workflow if I get a 1 returned or success constraint workflow if I get a 0 returned from stored proceedure

CREATE PROCEDURE CheckCatLog
@.OutSuccess INT
AS

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON
DECLARE @.RowCountCAT INT
DECLARE @.RowCountLOG INT

these totals should match
SELECT @.RowCountCAT = (SELECT Count(*) FROM mydb_Staging.dbo.S_CAT)
SELECT @.RowCountLOG = (SELECT Count(*) FROM mydb_Staging.dbo.S_LOG)
--PRINT @.RowCountCAT
--PRINT @.RowCountLOG
BEGIN
IF @.RowCountCAT <> @.RowCountLOG
--PRINT 'Volume of jobs from the CAT file does not match volume of jobs from the LOG file'
--RETURN 1
SET @.OutSuccess = 1
END
GO

Thanks in advance

Dave

Set ResultSet=None.

If OutSuccess is an OUTPUT parameter, you have to modify the second line in SP to "@.OutSuccess INT OUTPUT". If it is not an OUTPUT parameter, you have to modify the mapping direction in your task.

Also, if you are returning a value from the SP, you have to add a parameter (mapping direction: ReturnValue) to get the return value.
|||

Thanks for quick reply--opps I have fixed the SPROC see bold and set the result set in SSIS to none and still get the error--what I want to do is return the output from the Exec SQL task into a variable giBatchID Int32 and then connect to a script task and if value of giBatchID = 1 then fail the task and connect to an SMTP task to send an alert to the customer. The showstopper is the Execute SQL task with OLEDB connection to SQL server 2005 table--it simply does not work, there is no way that it will pick up a single row output from a mple OLEDB connection: Any ideas guys?

CREATE PROCEDURE CheckCatLog
@.OutSuccess INT OUTPUT
AS

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON
DECLARE @.RowCountCAT INT
DECLARE @.RowCountLOG INT

these totals should match
SELECT @.RowCountCAT = (SELECT Count(*) FROM mydb_Staging.dbo.S_CAT)
SELECT @.RowCountLOG = (SELECT Count(*) FROM mydb_Staging.dbo.S_LOG)
--PRINT @.RowCountCAT
--PRINT @.RowCountLOG
BEGIN
IF @.RowCountCAT <> @.RowCountLOG
--PRINT 'Volume of jobs from the CAT file does not match volume of jobs from the LOG file'
--RETURN 1
SET @.OutSuccess = 1

RETURN @.OutSuccess
END
GO

|||You can try Parameter Mapping, set direction to Output and map the parameter name 0 to the user variables.

Also set a default to @.OutSuccess to 0 instead of null
|||I do not understand why you would want to make OutSuccess an OUTPUT parameter and the return value.

My suggestion would be to make it just an OUTPUT paramter and not the return value. So, leave the second line in SP as it is, but comment out RETURN part. Set ResultSet=None in your task. Set SQLStatement="CheckCatLog ? OUTPUT". Then add an output parameter (variablename=giBatchID, Direction=Output, Type=Int32 and Parameter Name=0).

exec sql

I need help understanding the syntax of the "exec sql" statement.

i am looking at code that build an sql string such as

sql="exec SOMETHING Session("id")"

or something like that.

then, there is

conn.execute(sql)

My question is the "SOMETHING" in the sql statement...is what? I know it is user defined (object or variable or such), but what exactly is it? i look through the rest of the code and don;'t see SOMETHING defined elsewhere.

i am not sure if i am asking the question right. i don't understand what the SOMETHING is doing, or why it is there.

in particular, the code i am examining is

sql="exec SurveyDelete "&"'" & Session("StudentID") & " ' "
conn.execute(sql)

i understand the this statement will delete a record, but how does it handle "SurveyDelete", how does it know what the is when it is not defined anywhere else in the code?I would wager that SurveyDelete is the name of a stored procedure in the database. Have a look there.|||i bet your right. thanks.

Exec Process Task problem

I am trying to use a variable in an Execute Process Task

Here is my code that I use to set the variable and it works and has the right information:

Public Sub Main()

Dim serverNamePart As String = Mid(CStr(System.Environment.MachineName()), 1, 5)

Dts.Variables.Item("gvServerName").Value = (CStr(System.Environment.MachineName()))

Select Case serverNamePart

Case "ATCDE" 'Development server

Dts.Variables.Item("gvAppServer").Value = "ATCDEVRPNAPP01"

Case "ATCIN" 'Intergration server

Dts.Variables.Item("gvAppServer").Value = "ATCINTRPNAPP01"

Case "ATCDE" 'Development server

Dts.Variables.Item("gvAppServer").Value = "ATCQARPNAPP01"

Case "LTC1P" 'Development server

Dts.Variables.Item("gvAppServer").Value = "LTC1RPNAPP01 LTC1RPNAPP02 LTC1RPNAPP03 LTC1RPNAPP04"

End Select

' MsgBox(Dts.Variables.Item("gvServerName").Value)

MsgBox(Dts.Variables.Item("gvAppServer").Value)

Dts.TaskResult = Dts.Results.Success

End Sub

On my Execute Process task I have User::gvAppServer as my StandardInputVariable but when I execute the task I get

[Execute Process Task] Error: In Executing "D:\RPNUtility\bin\AutoTransmitCall.exe" "" at "", The process exit code was "1" while the expected was "0".

If I take out the StandardInputVariable and hard code the value in Arguments it works. What am I doing wrong?

Phil, I believe you want to parameterize your "Arguments" property rather than your StandardInputVariable property. Use the Expressions page of the Execute Process Editor to use your gvAppServer variable for Arguments.

Your StandardInputVariable would be used for data that is processed by an executable, rather than a parameter for it.

|||That looks like it worked. Thanks.

exec .sql file

Hi,
How do I exec a .sql file from a sql job(code)
ThanksOSQL - See BOL
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23Gr%23iLfNIHA.5980@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I exec a .sql file from a sql job(code)
> Thanks
>

EXEC (@SQLString) Problem.

Hi,
I am getting an error:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ','.

This is my code. What is wrong here?

CREATE TABLE #TotalsTemp (InvoiceNum varchar(25),
ShipperNum varchar (20),
InvoiceDate datetime,
PickupTransDate datetime,
ShipperName varchar(50),
ShipperName2 varchar(50),
ShipperAddr varchar(50),
ShipperCity varchar(50),
ShipperState varchar(6),
ShipperZip varchar(15),
bName1 varchar(100),
bName2 varchar(50),
bAddr1 varchar(50),
bCity varchar(50),
bState varchar(6),
bZip varchar(15),
bCountry varchar(50),
bPhone varchar(50),
TrackingNum varchar(20),
CustRef1 varchar(50),
CustRef2 varchar(50),
UPSZone varchar(3),
ServiceLevel varchar(50),
Weight int,
Lading varchar(70),
SMPCodeDesc varchar(255),
GrossCharge decimal(12,2),
Incentive decimal(12,2),
NetCharge decimal(12,2),
AccessorialTotal decimal(12,2),
CodeRefDesc varchar(50),
HundredWeight varchar(3))

--Inbound
SET @.LadingType = 'inbound'

SET @.SQLStr = 'INSERT INTO #TotalsTemp ' +
'SELECT ' + @.ReportData + '.InvoiceNum, ' +
@.ReportData + '.ShipperNum, ' +
@.ReportData + '.InvoiceDate, ' +
@.InvoiceData + '.PickupTransDate, ' +
@.AddrData + '.aName1, ' +
@.AddrData + '.aName2, ' +
@.AddrData + '.aAddr1, ' +
@.AddrData + '.aCity, ' +
@.AddrData + '.aState, ' +
@.AddrData + '.aZip, ' +
@.ReportData + '.bName1, ' +
@.AddrData + '.bName2, ' +
@.AddrData + '.bAddr1, ' +
@.ReportData + '.bCity, ' +
@.ReportData + '.bState, ' +
@.AddrData + '.bZip AS, ' +
@.AddrData + '.bCountry, ' +
@.AddrData + '.bPhone, ' +
@.ReportData + '.TrackingNum, ' +
@.InvoiceData + '.CustRef1, ' +
@.InvoiceData + '.CustRef2, ' +
@.ReportData + '.UPSZone, ' +
'tblLegendServiceLevel.ServiceLevel, ' +
@.ReportData + '.Weight, ' +
'tblLegendLading.Lading, ' +
'tblLegendSMPCodes.[Desc], ' +
@.InvoiceData + '.GrossCharge, ' +
@.ReportData + '.Incentive, ' +
@.ReportData + '.NetCharge, ' +
@.ReportData + '.AccessorialTotal, ' +
'tblCodeRef.[Desc], ' +
@.InvoiceData + '.HundredWeight ' +
'FROM ' + @.ReportData +
' INNER JOIN ' + @.InvoiceData + ' ON ' + @.ReportData + '.DataID = ' + @.InvoiceData + '.DataID ' +
'INNER JOIN ' + @.AddrData + ' ON ' + @.ReportData + '.DataID = ' + @.AddrData + '.DataID ' +
'INNER JOIN tblLegendServiceLevel ON ' + @.ReportData + '.ServiceStandard = tblLegendServiceLevel.ServiceStandard ' +
'INNER JOIN tblLegendLading ON ' + @.ReportData + '.LadingCode = tblLegendLading.LadingCode ' +
'INNER JOIN tblLegendSMPCodes ON ' + @.ReportData + '.SMP2 = tblLegendSMPCodes.SMPCode ' +
'INNER JOIN tblCodeRef ON ' + @.InvoiceData + '.ComRes = tblCodeRef.Code ' +
'INNER JOIN tblShipperNumberLookUp AS LookUp ON ' + @.ReportData + '.ShipperNum = LookUp.ShipperNumber ' +
'INNER JOIN tblOrg_Unit ON LookUp.OU_ID = tblOrg_Unit.OU_ID ' +
'INNER JOIN tblOrg_Unit_Hier ON tblOrg_Unit.OU_ID = tblOrg_Unit_Hier.child ' +
'INNER JOIN tblOrg_lvls ON tblOrg_Unit_Hier.child_level = tblOrg_lvls.OrgLvl ' +
'WHERE (' + @.ReportData + '.InvoiceDate BETWEEN ''' + CAST(@.startdate AS varchar) + ''' AND ''' + CAST(@.enddate AS varchar) + ''') AND ' +
'(tblOrg_Unit_Hier.parent = ' + CAST(@.Parent AS varchar) + ') AND ' +
'(tblOrg_lvls.Root = ' + CAST(@.Root AS varchar) + ') AND ' +
'(tblOrg_lvls.[Name] = ''' + @.OrgLvl + ''') AND ' +
'(tblLegendLading.LadingType = ''' + @.LadingType + ''')'

EXEC (@.SQLStr)If you supply the declares, that'd be a big help...|||Sorry, here are the declares:
CREATE PROCEDURE sp_InboundOutboundCSV
(
@.startdate datetime,
@.enddate datetime,
@.Parent int,
@.Root int,
@.LadingType varchar(20)
)

AS

BEGIN
SET NOCOUNT ON

DECLARE @.OrgLvl varchar(15)
SET @.OrgLvl = 'Shipper Number'

DECLARE @.ReportData varchar(50)
SET @.ReportData = 'tbl' + CAST(@.Root AS varchar) + 'ReportData'

DECLARE @.InvoiceData varchar(50)
SET @.InvoiceData = 'tbl' + CAST(@.Root AS varchar) + 'InvoiceData'

DECLARE @.ShipperData varchar(50)
SET @.ShipperData = 'tbl' + CAST(@.Root AS varchar) + 'ShipperData'

DECLARE @.AddrData varchar(50)
SET @.AddrData = 'tbl' + CAST(@.Root AS varchar) + 'AddrData'

DECLARE @.SQLStr varchar(8000)|||This compiles fine...it's something else...

DECLARE @.startdate datetime,
@.enddate datetime,
@.Parent int,
@.Root int,
@.LadingType varchar(20)
DECLARE @.OrgLvl varchar(15)
SET @.OrgLvl = 'Shipper Number'

DECLARE @.ReportData varchar(50)
SET @.ReportData = 'tbl' + CAST(@.Root AS varchar) + 'ReportData'

DECLARE @.InvoiceData varchar(50)
SET @.InvoiceData = 'tbl' + CAST(@.Root AS varchar) + 'InvoiceData'

DECLARE @.ShipperData varchar(50)
SET @.ShipperData = 'tbl' + CAST(@.Root AS varchar) + 'ShipperData'

DECLARE @.AddrData varchar(50)
SET @.AddrData = 'tbl' + CAST(@.Root AS varchar) + 'AddrData'

DECLARE @.SQLStr varchar(8000)

SET @.SQLStr = 'INSERT INTO #TotalsTemp ' +
'SELECT ' + @.ReportData + '.InvoiceNum, ' +
@.ReportData + '.ShipperNum, ' +
@.ReportData + '.InvoiceDate, ' +
@.InvoiceData + '.PickupTransDate, ' +
@.AddrData + '.aName1, ' +
@.AddrData + '.aName2, ' +
@.AddrData + '.aAddr1, ' +
@.AddrData + '.aCity, ' +
@.AddrData + '.aState, ' +
@.AddrData + '.aZip, ' +
@.ReportData + '.bName1, ' +
@.AddrData + '.bName2, ' +
@.AddrData + '.bAddr1, ' +
@.ReportData + '.bCity, ' +
@.ReportData + '.bState, ' +
@.AddrData + '.bZip AS, ' +
@.AddrData + '.bCountry, ' +
@.AddrData + '.bPhone, ' +
@.ReportData + '.TrackingNum, ' +
@.InvoiceData + '.CustRef1, ' +
@.InvoiceData + '.CustRef2, ' +
@.ReportData + '.UPSZone, ' +
'tblLegendServiceLevel.ServiceLevel, ' +
@.ReportData + '.Weight, ' +
'tblLegendLading.Lading, ' +
'tblLegendSMPCodes.[Desc], ' +
@.InvoiceData + '.GrossCharge, ' +
@.ReportData + '.Incentive, ' +
@.ReportData + '.NetCharge, ' +
@.ReportData + '.AccessorialTotal, ' +
'tblCodeRef.[Desc], ' +
@.InvoiceData + '.HundredWeight ' +
'FROM ' + @.ReportData +
' INNER JOIN ' + @.InvoiceData + ' ON ' + @.ReportData + '.DataID = ' + @.InvoiceData + '.DataID ' +
'INNER JOIN ' + @.AddrData + ' ON ' + @.ReportData + '.DataID = ' + @.AddrData + '.DataID ' +
'INNER JOIN tblLegendServiceLevel ON ' + @.ReportData + '.ServiceStandard = tblLegendServiceLevel.ServiceStandard ' +
'INNER JOIN tblLegendLading ON ' + @.ReportData + '.LadingCode = tblLegendLading.LadingCode ' +
'INNER JOIN tblLegendSMPCodes ON ' + @.ReportData + '.SMP2 = tblLegendSMPCodes.SMPCode ' +
'INNER JOIN tblCodeRef ON ' + @.InvoiceData + '.ComRes = tblCodeRef.Code ' +
'INNER JOIN tblShipperNumberLookUp AS LookUp ON ' + @.ReportData + '.ShipperNum = LookUp.ShipperNumber ' +
'INNER JOIN tblOrg_Unit ON LookUp.OU_ID = tblOrg_Unit.OU_ID ' +
'INNER JOIN tblOrg_Unit_Hier ON tblOrg_Unit.OU_ID = tblOrg_Unit_Hier.child ' +
'INNER JOIN tblOrg_lvls ON tblOrg_Unit_Hier.child_level = tblOrg_lvls.OrgLvl ' +
'WHERE (' + @.ReportData + '.InvoiceDate BETWEEN ''' + CAST(@.startdate AS varchar) + ''' AND ''' + CAST(@.enddate AS varchar) + ''') AND ' +
'(tblOrg_Unit_Hier.parent = ' + CAST(@.Parent AS varchar) + ') AND ' +
'(tblOrg_lvls.Root = ' + CAST(@.Root AS varchar) + ') AND ' +
'(tblOrg_lvls.[Name] = ''' + @.OrgLvl + ''') AND ' +
'(tblLegendLading.LadingType = ''' + @.LadingType + ''')'|||Table compiles fine as well....

Post the whole sproc...

it's massive, isn't it.....|||Yes it is, but here t is... :) I have to submit it in parts since I can only post 1000 characters.
It does compile fine, but because I use EXEC a string I create it won't show you the error until you execute it.:

CREATE PROCEDURE sp_InboundOutboundCSV
(
@.startdate datetime,
@.enddate datetime,
@.Parent int,
@.Root int,
@.LadingType varchar(20)
)

AS

BEGIN
SET NOCOUNT ON

DECLARE @.OrgLvl varchar(15)
SET @.OrgLvl = 'Shipper Number'

DECLARE @.ReportData varchar(50)
SET @.ReportData = 'tbl' + CAST(@.Root AS varchar) + 'ReportData'

DECLARE @.InvoiceData varchar(50)
SET @.InvoiceData = 'tbl' + CAST(@.Root AS varchar) + 'InvoiceData'

DECLARE @.ShipperData varchar(50)
SET @.ShipperData = 'tbl' + CAST(@.Root AS varchar) + 'ShipperData'

DECLARE @.AddrData varchar(50)
SET @.AddrData = 'tbl' + CAST(@.Root AS varchar) + 'AddrData'

DECLARE @.SQLStr varchar(8000)

IF @.LadingType ='' GOTO TotalsReport
IF @.LadingType <>'' GOTO LadingReport

LadingReport:
IF LOWER(@.LadingType) ='inbound' GOTO InboundReport
IF LOWER(@.LadingType) ='outbound' GOTO OutboundReport

OutboundReport:
BEGIN
SET @.SQLStr = 'SELECT ' + @.ReportData + '.InvoiceNum AS InvoiceNumber, ' +
@.ReportData + '.ShipperNum AS ShipperNumber, ' +
@.ReportData + '.InvoiceDate AS InvoiceDate, ' +
@.InvoiceData + '.PickupTransDate AS ShipDate, ' +
@.ShipperData + '.ShipperName AS ShipperName, ' +
@.ShipperData + '.ShipperName2 AS ShipperCompName, ' +
@.ShipperData + '.ShipperAddr AS ShipperAddr, ' +
@.ShipperData + '.ShipperCity AS ShipperCity, ' +
@.ShipperData + '.ShipperState AS ShipperState, ' +
@.ShipperData + '.ShipperZip AS ShipperZip, ' +
@.ReportData + '.bName1 AS ConsigneeName, ' +
@.AddrData + '.bName2 AS ConsigneeCompName, ' +
@.AddrData + '.bAddr1 AS ConsigneeAddr, ' +
@.ReportData + '.bCity AS ConsigneeCity, ' +
@.ReportData + '.bState AS ConsigneeState, ' +
@.AddrData + '.bZip AS ConsigneeZip, ' +
@.AddrData + '.bCountry AS ConsigneeCountry, ' +
@.AddrData + '.bPhone AS ConsigneePhone, ' +
@.ReportData + '.TrackingNum AS TrackingNum, ' +
@.InvoiceData + '.CustRef1 AS RefNum1, ' +
@.InvoiceData + '.CustRef2 AS RefNum2, ' +
@.ReportData + '.UPSZone AS Zone, ' +
'tblLegendServiceLevel.ServiceLevel AS ServiceLevel, ' +
@.ReportData + '.Weight AS Weight, ' +
'tblLegendLading.Lading AS LadingDesc, ' +
'tblLegendSMPCodes.[Desc] AS SMPDesc, ' +
@.InvoiceData + '.GrossCharge AS GrossCharge, ' +
@.ReportData + '.Incentive AS Incentive, ' +
@.ReportData + '.NetCharge AS NetCharge, ' +
@.ReportData + '.AccessorialTotal AS AccessorialTotal, ' +
'tblCodeRef.[Desc] AS ComResDesc, ' +
@.InvoiceData + '.HundredWeight AS HundredWeight ' +
'FROM ' + @.ReportData +
' INNER JOIN ' + @.InvoiceData + ' ON ' + @.ReportData + '.DataID = ' + @.InvoiceData + '.DataID ' +
'INNER JOIN ' + @.AddrData + ' ON ' + @.ReportData + '.DataID = ' + @.AddrData + '.DataID ' +
'INNER JOIN ' + @.ShipperData + ' ON ' + @.ReportData + '.DataID = ' + @.ShipperData + '.DataID ' +
'INNER JOIN tblLegendServiceLevel ON ' + @.ReportData + '.ServiceStandard = tblLegendServiceLevel.ServiceStandard ' +
'INNER JOIN tblLegendLading ON ' + @.ReportData + '.LadingCode = tblLegendLading.LadingCode ' +
'INNER JOIN tblLegendSMPCodes ON ' + @.ReportData + '.SMP2 = tblLegendSMPCodes.SMPCode ' +
'INNER JOIN tblCodeRef ON ' + @.InvoiceData + '.ComRes = tblCodeRef.Code ' +
'INNER JOIN tblShipperNumberLookUp AS LookUp ON ' + @.ReportData + '.ShipperNum = LookUp.ShipperNumber ' +
'INNER JOIN tblOrg_Unit ON LookUp.OU_ID = tblOrg_Unit.OU_ID ' +
'INNER JOIN tblOrg_Unit_Hier ON tblOrg_Unit.OU_ID = tblOrg_Unit_Hier.child ' +
'INNER JOIN tblOrg_lvls ON tblOrg_Unit_Hier.child_level = tblOrg_lvls.OrgLvl ' +
'WHERE (' + @.ReportData + '.InvoiceDate BETWEEN ''' + CAST(@.startdate AS varchar) + ''' AND ''' + CAST(@.enddate AS varchar) + ''') AND ' +
'(tblLegendLading.LadingType = ''' + @.LadingType + ''') AND ' +
'(tblOrg_Unit_Hier.parent = ' + CAST(@.Parent AS varchar) + ') AND ' +
'(tblOrg_lvls.Root = ' + CAST(@.Root AS varchar) + ') AND ' +
'(tblOrg_lvls.[Name] = ''' + @.OrgLvl + ''') '
EXEC (@.SQLStr)

END

GOTO Done|||InboundReport:
BEGIN
SET @.SQLStr = 'SELECT ' + @.ReportData + '.InvoiceNum AS InvoiceNumber, ' +
@.ReportData + '.ShipperNum AS ShipperNumber, ' +
@.ReportData + '.InvoiceDate AS InvoiceDate, ' +
@.InvoiceData + '.PickupTransDate AS ShipDate, ' +
@.AddrData + '.aName1 AS ShipperName, ' +
@.AddrData + '.aName2 AS ShipperCompName, ' +
@.AddrData + '.aAddr1 AS ShipperAddr, ' +
@.AddrData + '.aCity AS ShipperCity, ' +
@.AddrData + '.aState AS ShipperState, ' +
@.AddrData + '.aZip AS ShipperZip, ' +
@.ReportData + '.bName1 AS ConsigneeName, ' +
@.AddrData + '.bName2 AS ConsigneeCompName, ' +
@.AddrData + '.bAddr1 AS ConsigneeAddr, ' +
@.ReportData + '.bCity AS ConsigneeCity, ' +
@.ReportData + '.bState AS ConsigneeState, ' +
@.AddrData + '.bZip AS ConsigneeZip, ' +
@.AddrData + '.bCountry AS ConsigneeCountry, ' +
@.AddrData + '.bPhone AS ConsigneePhone, ' +
@.ReportData + '.TrackingNum AS TrackingNum, ' +
@.InvoiceData + '.CustRef1 AS RefNum1, ' +
@.InvoiceData + '.CustRef2 AS RefNum2, ' +
@.ReportData + '.UPSZone AS Zone, ' +
'tblLegendServiceLevel.ServiceLevel AS ServiceLevel, ' +
@.ReportData + '.Weight AS Weight, ' +
'tblLegendLading.Lading AS LadingDesc, ' +
'tblLegendSMPCodes.[Desc] AS SMPDesc, ' +
@.InvoiceData + '.GrossCharge AS GrossCharge, ' +
@.ReportData + '.Incentive AS Incentive, ' +
@.ReportData + '.NetCharge AS NetCharge, ' +
@.ReportData + '.AccessorialTotal AS AccessorialTotal, ' +
'tblCodeRef.[Desc] AS ComResDesc, ' +
@.InvoiceData + '.HundredWeight AS HundredWeight ' +
'FROM ' + @.ReportData +
' INNER JOIN ' + @.InvoiceData + ' ON ' + @.ReportData + '.DataID = ' + @.InvoiceData + '.DataID ' +
'INNER JOIN ' + @.AddrData + ' ON ' + @.ReportData + '.DataID = ' + @.AddrData + '.DataID ' +
'INNER JOIN tblLegendServiceLevel ON ' + @.ReportData + '.ServiceStandard = tblLegendServiceLevel.ServiceStandard ' +
'INNER JOIN tblLegendLading ON ' + @.ReportData + '.LadingCode = tblLegendLading.LadingCode ' +
'INNER JOIN tblLegendSMPCodes ON ' + @.ReportData + '.SMP2 = tblLegendSMPCodes.SMPCode ' +
'INNER JOIN tblCodeRef ON ' + @.InvoiceData + '.ComRes = tblCodeRef.Code ' +
'INNER JOIN tblShipperNumberLookUp AS LookUp ON ' + @.ReportData + '.ShipperNum = LookUp.ShipperNumber ' +
'INNER JOIN tblOrg_Unit ON LookUp.OU_ID = tblOrg_Unit.OU_ID ' +
'INNER JOIN tblOrg_Unit_Hier ON tblOrg_Unit.OU_ID = tblOrg_Unit_Hier.child ' +
'INNER JOIN tblOrg_lvls ON tblOrg_Unit_Hier.child_level = tblOrg_lvls.OrgLvl ' +
'WHERE (' + @.ReportData + '.InvoiceDate BETWEEN ''' + CAST(@.startdate AS varchar) + ''' AND ''' + CAST(@.enddate AS varchar) + ''') AND ' +
'(tblLegendLading.LadingType = ''' + @.LadingType + ''') AND ' +
'(tblOrg_Unit_Hier.parent = ' + CAST(@.Parent AS varchar) + ') AND ' +
'(tblOrg_lvls.Root = ' + CAST(@.Root AS varchar) + ') AND ' +
'(tblOrg_lvls.[Name] = ''' + @.OrgLvl + ''') '
EXEC (@.SQLStr)

END

GOTO Done|||TotalsReport:

BEGIN
CREATE TABLE #TotalsTemp (InvoiceNum varchar(25),
ShipperNum varchar (20),
InvoiceDate datetime,
PickupTransDate datetime,
ShipperName varchar(50),
ShipperName2 varchar(50),
ShipperAddr varchar(50),
ShipperCity varchar(50),
ShipperState varchar(6),
ShipperZip varchar(15),
bName1 varchar(100),
bName2 varchar(50),
bAddr1 varchar(50),
bCity varchar(50),
bState varchar(6),
bZip varchar(15),
bCountry varchar(50),
bPhone varchar(50),
TrackingNum varchar(20),
CustRef1 varchar(50),
CustRef2 varchar(50),
UPSZone varchar(3),
ServiceLevel varchar(50),
Weight int,
Lading varchar(70),
SMPCodeDesc varchar(255),
GrossCharge decimal(12,2),
Incentive decimal(12,2),
NetCharge decimal(12,2),
AccessorialTotal decimal(12,2),
CodeRefDesc varchar(50),
HundredWeight varchar(3))

--Inbound
SET @.LadingType = 'inbound'

SET @.SQLStr = 'INSERT INTO #TotalsTemp ' +
'SELECT ' + @.ReportData + '.InvoiceNum, ' +
@.ReportData + '.ShipperNum, ' +
@.ReportData + '.InvoiceDate, ' +
@.InvoiceData + '.PickupTransDate, ' +
@.AddrData + '.aName1, ' +
@.AddrData + '.aName2, ' +
@.AddrData + '.aAddr1, ' +
@.AddrData + '.aCity, ' +
@.AddrData + '.aState, ' +
@.AddrData + '.aZip, ' +
@.ReportData + '.bName1, ' +
@.AddrData + '.bName2, ' +
@.AddrData + '.bAddr1, ' +
@.ReportData + '.bCity, ' +
@.ReportData + '.bState, ' +
@.AddrData + '.bZip AS, ' +
@.AddrData + '.bCountry, ' +
@.AddrData + '.bPhone, ' +
@.ReportData + '.TrackingNum, ' +
@.InvoiceData + '.CustRef1, ' +
@.InvoiceData + '.CustRef2, ' +
@.ReportData + '.UPSZone, ' +
'tblLegendServiceLevel.ServiceLevel, ' +
@.ReportData + '.Weight, ' +
'tblLegendLading.Lading, ' +
'tblLegendSMPCodes.[Desc], ' +
@.InvoiceData + '.GrossCharge, ' +
@.ReportData + '.Incentive, ' +
@.ReportData + '.NetCharge, ' +
@.ReportData + '.AccessorialTotal, ' +
'tblCodeRef.[Desc], ' +
@.InvoiceData + '.HundredWeight ' +
'FROM ' + @.ReportData +
' INNER JOIN ' + @.InvoiceData + ' ON ' + @.ReportData + '.DataID = ' + @.InvoiceData + '.DataID ' +
'INNER JOIN ' + @.AddrData + ' ON ' + @.ReportData + '.DataID = ' + @.AddrData + '.DataID ' +
'INNER JOIN tblLegendServiceLevel ON ' + @.ReportData + '.ServiceStandard = tblLegendServiceLevel.ServiceStandard ' +
'INNER JOIN tblLegendLading ON ' + @.ReportData + '.LadingCode = tblLegendLading.LadingCode ' +
'INNER JOIN tblLegendSMPCodes ON ' + @.ReportData + '.SMP2 = tblLegendSMPCodes.SMPCode ' +
'INNER JOIN tblCodeRef ON ' + @.InvoiceData + '.ComRes = tblCodeRef.Code ' +
'INNER JOIN tblShipperNumberLookUp AS LookUp ON ' + @.ReportData + '.ShipperNum = LookUp.ShipperNumber ' +
'INNER JOIN tblOrg_Unit ON LookUp.OU_ID = tblOrg_Unit.OU_ID ' +
'INNER JOIN tblOrg_Unit_Hier ON tblOrg_Unit.OU_ID = tblOrg_Unit_Hier.child ' +
'INNER JOIN tblOrg_lvls ON tblOrg_Unit_Hier.child_level = tblOrg_lvls.OrgLvl ' +
'WHERE (' + @.ReportData + '.InvoiceDate BETWEEN ''' + CAST(@.startdate AS varchar) + ''' AND ''' + CAST(@.enddate AS varchar) + ''') AND ' +
'(tblOrg_Unit_Hier.parent = ' + CAST(@.Parent AS varchar) + ') AND ' +
'(tblOrg_lvls.Root = ' + CAST(@.Root AS varchar) + ') AND ' +
'(tblOrg_lvls.[Name] = ''' + @.OrgLvl + ''') AND ' +
'(tblLegendLading.LadingType = ''' + @.LadingType + ''')'
EXEC (@.SQLStr)

--Outbound
SET @.LadingType = 'outbound'

SET @.SQLStr = 'INSERT INTO #TotalsTemp ' +
'SELECT ' + @.ReportData + '.InvoiceNum, ' +
@.ReportData + '.ShipperNum, ' +
@.ReportData + '.InvoiceDate, ' +
@.InvoiceData + '.PickupTransDate, ' +
@.ShipperData + '.ShipperName, ' +
@.ShipperData + '.ShipperName2, ' +
@.ShipperData + '.ShipperAddr, ' +
@.ShipperData + '.ShipperCity, ' +
@.ShipperData + '.ShipperState, ' +
@.ShipperData + '.ShipperZip, ' +
@.ReportData + '.bName1, ' +
@.AddrData + '.bName2, ' +
@.AddrData + '.bAddr1, ' +
@.ReportData + '.bCity, ' +
@.ReportData + '.bState, ' +
@.AddrData + '.bZip AS, ' +
@.AddrData + '.bCountry, ' +
@.AddrData + '.bPhone, ' +
@.ReportData + '.TrackingNum, ' +
@.InvoiceData + '.CustRef1, ' +
@.InvoiceData + '.CustRef2, ' +
@.ReportData + '.UPSZone, ' +
'tblLegendServiceLevel.ServiceLevel, ' +
@.ReportData + '.Weight, ' +
'tblLegendLading.Lading, ' +
'tblLegendSMPCodes.[Desc], ' +
@.InvoiceData + '.GrossCharge, ' +
@.ReportData + '.Incentive, ' +
@.ReportData + '.NetCharge, ' +
@.ReportData + '.AccessorialTotal, ' +
'tblCodeRef.[Desc], ' +
@.InvoiceData + '.HundredWeight ' +
'FROM ' + @.ReportData +
' INNER JOIN ' + @.InvoiceData + ' ON ' + @.ReportData + '.DataID = ' + @.InvoiceData + '.DataID ' +
'INNER JOIN ' + @.AddrData + ' ON ' + @.ReportData + '.DataID = ' + @.AddrData + '.DataID ' +
'INNER JOIN ' + @.ShipperData + ' ON ' + @.ReportData + '.DataID = ' + @.ShipperData + '.DataID ' +
'INNER JOIN tblLegendServiceLevel ON ' + @.ReportData + '.ServiceStandard = tblLegendServiceLevel.ServiceStandard ' +
'INNER JOIN tblLegendLading ON ' + @.ReportData + '.LadingCode = tblLegendLading.LadingCode ' +
'INNER JOIN tblLegendSMPCodes ON ' + @.ReportData + '.SMP2 = tblLegendSMPCodes.SMPCode ' +
'INNER JOIN tblCodeRef ON ' + @.InvoiceData + '.ComRes = tblCodeRef.Code ' +
'INNER JOIN tblShipperNumberLookUp AS LookUp ON ' + @.ReportData + '.ShipperNum = LookUp.ShipperNumber ' +
'INNER JOIN tblOrg_Unit ON LookUp.OU_ID = tblOrg_Unit.OU_ID ' +
'INNER JOIN tblOrg_Unit_Hier ON tblOrg_Unit.OU_ID = tblOrg_Unit_Hier.child ' +
'INNER JOIN tblOrg_lvls ON tblOrg_Unit_Hier.child_level = tblOrg_lvls.OrgLvl ' +
'WHERE (' + @.ReportData + '.InvoiceDate BETWEEN ''' + CAST(@.startdate AS varchar) + ''' AND ''' + CAST(@.enddate AS varchar) + ''') AND ' +
'(tblOrg_Unit_Hier.parent = ' + CAST(@.Parent AS varchar) + ') AND ' +
'(tblOrg_lvls.Root = ' + CAST(@.Root AS varchar) + ') AND ' +
'(tblOrg_lvls.[Name] = ''' + @.OrgLvl + ''') AND ' +
'(tblLegendLading.LadingType = ''' + @.LadingType + ''')'
EXEC (@.SQLStr)

--Misc
SET @.LadingType = 'misc'

SET @.SQLStr = 'INSERT INTO #TotalsTemp ' +
'SELECT ' + @.ReportData + '.InvoiceNum, ' +
@.ReportData + '.ShipperNum, ' +
@.ReportData + '.InvoiceDate, ' +
@.InvoiceData + '.PickupTransDate, ' +
@.ShipperData + '.ShipperName, ' +
@.ShipperData + '.ShipperName2, ' +
@.ShipperData + '.ShipperAddr, ' +
@.ShipperData + '.ShipperCity, ' +
@.ShipperData + '.ShipperState, ' +
@.ShipperData + '.ShipperZip, ' +
@.ReportData + '.bName1, ' +
@.AddrData + '.bName2, ' +
@.AddrData + '.bAddr1, ' +
@.ReportData + '.bCity, ' +
@.ReportData + '.bState, ' +
@.AddrData + '.bZip AS, ' +
@.AddrData + '.bCountry, ' +
@.AddrData + '.bPhone, ' +
@.ReportData + '.TrackingNum, ' +
@.InvoiceData + '.CustRef1, ' +
@.InvoiceData + '.CustRef2, ' +
@.ReportData + '.UPSZone, ' +
'tblLegendServiceLevel.ServiceLevel, ' +
@.ReportData + '.Weight, ' +
'tblLegendLading.Lading, ' +
'tblLegendSMPCodes.[Desc], ' +
@.InvoiceData + '.GrossCharge, ' +
@.ReportData + '.Incentive, ' +
@.ReportData + '.NetCharge, ' +
@.ReportData + '.AccessorialTotal, ' +
'tblCodeRef.[Desc], ' +
@.InvoiceData + '.HundredWeight ' +
'FROM ' + @.ReportData +
' INNER JOIN ' + @.InvoiceData + ' ON ' + @.ReportData + '.DataID = ' + @.InvoiceData + '.DataID ' +
'INNER JOIN ' + @.AddrData + ' ON ' + @.ReportData + '.DataID = ' + @.AddrData + '.DataID ' +
'INNER JOIN ' + @.ShipperData + ' ON ' + @.ReportData + '.DataID = ' + @.ShipperData + '.DataID ' +
'INNER JOIN tblLegendServiceLevel ON ' + @.ReportData + '.ServiceStandard = tblLegendServiceLevel.ServiceStandard ' +
'INNER JOIN tblLegendLading ON ' + @.ReportData + '.LadingCode = tblLegendLading.LadingCode ' +
'INNER JOIN tblLegendSMPCodes ON ' + @.ReportData + '.SMP2 = tblLegendSMPCodes.SMPCode ' +
'INNER JOIN tblCodeRef ON ' + @.InvoiceData + '.ComRes = tblCodeRef.Code ' +
'INNER JOIN tblShipperNumberLookUp AS LookUp ON ' + @.ReportData + '.ShipperNum = LookUp.ShipperNumber ' +
'INNER JOIN tblOrg_Unit ON LookUp.OU_ID = tblOrg_Unit.OU_ID ' +
'INNER JOIN tblOrg_Unit_Hier ON tblOrg_Unit.OU_ID = tblOrg_Unit_Hier.child ' +
'INNER JOIN tblOrg_lvls ON tblOrg_Unit_Hier.child_level = tblOrg_lvls.OrgLvl ' +
'WHERE (' + @.ReportData + '.InvoiceDate BETWEEN ''' + CAST(@.startdate AS varchar) + ''' AND ''' + CAST(@.enddate AS varchar) + ''') AND ' +
'(tblOrg_Unit_Hier.parent = ' + CAST(@.Parent AS varchar) + ') AND ' +
'(tblOrg_lvls.Root = ' + CAST(@.Root AS varchar) + ') AND ' +
'(tblOrg_lvls.[Name] = ''' + @.OrgLvl + ''') AND ' +
'(tblLegendLading.LadingType = ''' + @.LadingType + ''')'
EXEC (@.SQLStr)

SELECT InvoiceNum AS InvoiceNumber,
ShipperNum AS ShipperNumber,
InvoiceDate AS InvoiceDate,
PickupTransDate AS ShipDate,
ShipperName AS ShipperName,
ShipperName2 AS ShipperCompName,
ShipperAddr AS ShipperAddr,
ShipperCity AS ShipperCity,
ShipperState AS ShipperState,
ShipperZip AS ShipperZip,
bName1 AS ConsigneeName,
bName2 AS ConsigneeCompName,
bAddr1 AS ConsigneeAddr,
bCity AS ConsigneeCity,
bState AS ConsigneeState,
bZip AS ConsigneeZip,
bCountry AS ConsigneeCountry,
bPhone AS ConsigneePhone,
TrackingNum AS TrackingNum,
CustRef1 AS RefNum1,
CustRef2 AS RefNum2,
UPSZone AS Zone,
ServiceLevel AS ServiceLevel,
Weight AS Weight,
Lading AS LadingDesc,
SMPCodeDesc AS SMPDesc,
GrossCharge AS GrossCharge,
Incentive AS Incentive,
NetCharge AS NetCharge,
AccessorialTotal AS AccessorialTotal,
CodeRefDesc AS ComResDesc,
HundredWeight AS HundredWeight
FROM #TotalsTemp
ORDER BY Lading

END

GOTO Done

Done:

END
GO|||So it's the execute that throws the error...

Instead of doing EXEC do SELECT @.SQLStr and take a look at it...can you post just that?

That'll be easier to debug...

Hey what's an extra 4 post counts...|||Well I get the error when I call the sproc. I don't think that the EXEC throws the error because this sproc worked fine with EXEC until I needed to make a chage on the bottom section starting with TotalsReport. so if you look at my original post it shows only that section and my second post shows all the declare's.

Thanks for your help.

P.S. the more posts the better :)|||What I'm suggesting is that the SQL statement is malformed...just putting the string together is fine...it's when you execute the sql that there's a problem (well, like duh brett)...

I was suggesting post what it buils...should be easier to see,,,wait...I can do that...|||YUP!

INSERT INTO #TotalsTemp SELECT tbl1ReportData.InvoiceNum, tbl1ReportData.ShipperNum, tbl1ReportData.InvoiceDate
, tbl1InvoiceData.PickupTransDate, tbl1AddrData.aName1, tbl1AddrData.aName2, tbl1AddrData.aAddr1
, tbl1AddrData.aCity, tbl1AddrData.aState, tbl1AddrData.aZip, tbl1ReportData.bName1, tbl1AddrData.bName2
, tbl1AddrData.bAddr1, tbl1ReportData.bCity, tbl1ReportData.bState, tbl1AddrData.bZip AS, tbl1AddrData.bCountry
, tbl1AddrData.bPhone, tbl1ReportData.TrackingNum, tbl1InvoiceData.CustRef1, tbl1InvoiceData.CustRef2
, tbl1ReportData.UPSZone, tblLegendServiceLevel.ServiceLevel, tbl1ReportData.Weight, tblLegendLading.Lading
, tblLegendSMPCodes.[Desc], tbl1InvoiceData.GrossCharge, tbl1ReportData.Incentive, tbl1ReportData.NetCharge
, tbl1ReportData.AccessorialTotal, tblCodeRef.[Desc], tbl1InvoiceData.HundredWeight
FROM tbl1ReportData INNER JOIN tbl1InvoiceData ON tbl1ReportData.DataID = tbl1InvoiceData.DataID
INNER JOIN tbl1AddrData ON tbl1ReportData.DataID = tbl1AddrData.DataID
INNER JOIN tblLegendServiceLevel ON tbl1ReportData.ServiceStandard = tblLegendServiceLevel.ServiceStandard
INNER JOIN tblLegendLading ON tbl1ReportData.LadingCode = tblLegendLading.LadingCode
INNER JOIN tblLegendSMPCodes ON tbl1ReportData.SMP2 = tblLegendSMPCodes.SMPCode
INNER JOIN tblCodeRef ON tbl1InvoiceData.ComRes = tblCodeRef.Code
INNER JOIN tblShipperNumberLookUp AS LookUp ON tbl1ReportData.ShipperNum = LookUp.ShipperNumber
INNER JOIN tblOrg_Unit ON LookUp.OU_ID = tblOrg_Unit.OU_ID
INNER JOIN tblOrg_Unit_Hier ON tblOrg_Unit.OU_ID = tblOrg_Unit_Hier.child
INNER JOIN tblOrg_lvls ON tblOrg_Unit_Hier.child_level = tblOrg_lvls.OrgLvl
WHERE (tbl1ReportData.InvoiceDate BETWEEN 'Mar 17 2004 12:00AM' AND 'Mar 17 2004 12:00AM')
AND (tblOrg_Unit_Hier.parent = 1) AND (tblOrg_lvls.Root = 1) AND (tblOrg_lvls.[Name] = 'Shipper Number')
AND (tblLegendLading.LadingType = 'Brett')|||WOW, I can't beleive I missed that. But with an sproc like this, it's bound to happend.

Thank you so much.

EXEC

Hi,

I have a written a SP to do indexdefrag to all user table indexes in a databases...I had to use dynamic sql so I can reuse this code for any DB...

declare @.strsql varchar(500)

set @.strsql = ' dbcc indexdefrag('+'''DBName'''+',554556545,3)'

exec (@.strsql)

When I execute the above script, I immeaditely see the results in the query analyser like below:

Pages Scanned Pages Moved Pages Removed
- -- -
3 0 0

Looks like the indexdefrag did not happen since the logical fragmentation is still a high number like 30%.....

Just wondering whats goin on..

Thanks.

Ranga

Please take a look at the whitepaper below. That should answer most of your questions.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

|||Thanks Umachandar...the article was enlightening...

excuting xp_sendmail

When excuting the xp_sendmail in the Query analyzer, my mail gets send. When doing this in my code it doesn't work eventhough I explicitly use startmailn then xp_sendmail and then sp_stopmail? I think this is a problem of user rights? I gave my user as parameter but even then it didn't work. Any suggestions? I'm pretty sure, the used code is correct.

greetings,
Geoffhumm.

Make sure you configure both the server and the SQL Server Agent to send mail. You do this by specifying the mail profile and running a quick test.

Exclude child nodes i Select

Hi
Have this code, http://code.doria.se/?c=21, that I found at CodeProject.com.
(http://www.codeproject.com/cs/datab...L_databases.asp)
To the Node table I have added a IsActive column, that you can see is being
used in the last query.
select c.*
from Node n, Tree t, Node c
where n.NodeName = 'Volvo'
and n.Id = t.ParentId
and t.Id = c.Id
and c.IsActive = 1
Result:
2 1 Volvo 1
4 2 740 1
7 2 Turbo 1
The problem is that I want the child nodes of a node that is IsActive = 0 to
be excluded from the result as well. In this case the childnode "Turbo"
shouldn't be included cause its parent "940" is not IsActive.
Does anyone have any solution to this?
Thanks.Sorry, the Insert for "Turbo" should be:
insert into Node(ParentId, NodeName) values(5, 'Turbo')
"Senna" wrote:

> Hi
> Have this code, http://code.doria.se/?c=21, that I found at CodeProject.co
m.
> (http://www.codeproject.com/cs/datab...L_databases.asp)
> To the Node table I have added a IsActive column, that you can see is bein
g
> used in the last query.
> select c.*
> from Node n, Tree t, Node c
> where n.NodeName = 'Volvo'
> and n.Id = t.ParentId
> and t.Id = c.Id
> and c.IsActive = 1
> Result:
> 2 1 Volvo 1
> 4 2 740 1
> 7 2 Turbo 1
> The problem is that I want the child nodes of a node that is IsActive = 0
to
> be excluded from the result as well. In this case the childnode "Turbo"
> shouldn't be included cause its parent "940" is not IsActive.
> Does anyone have any solution to this?
> Thanks.|||Have a look at this example:
http://milambda.blogspot.com/2005/0...or-monkeys.html
It may not be exactly what you need, but it could lead you in the right
direction.
ML
http://milambda.blogspot.com/

Exceptions

How do I code an exception to terminate a transaction?
How do I code an exception so that it doesn't terminate the program?Hello,

If you want to stop a transaction via exception handling or with other techniques, use something like this

.
.
.
WHILE cuCursor%FOUND LOOP
EXIT WHEN cuCursor.field = 'exit'
END WHILE;

or

WHILE cuCursor%FOUND LOOP
IF cuCursor.field = 'exit'
GOTO EndLabel
END IF;
END WHILE;

<<EndLabel>>
.
.
.

or

WHILE cuCursor%FOUND LOOP
IF cuCursor.field = 'exit'
THROW endException
END IF;
END WHILE;

If your want to catch a exception use something like this

WHILE cuCursor%FOUND LOOP
BEGIN
nNumber = 'abc';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
END WHILE;

Hope that helps ?

Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.com|||Thank you, it helped

Originally posted by bbk
How do I code an exception to terminate a transaction?
How do I code an exception so that it doesn't terminate the program?

EXCEPTION_ACCESS_VIOLATION crash

Hello,
I have a serious problem with MS SQL Server 2005 version 9.00.3042.00,
platform NT AMD64 (Windows 2003 64bit R2).
It seems our code triggers an internal exception EXCEPTION_ACCESS_VIOLATION
(see SQLDump0011.log file). It happened 5 times within last 2 months (btw
there was SQL Server 2005 SP1 first 3 times).
The FUPDispatch procedure is run under SQL Server Agent. It calls a couple
of reconciliation procedures by
Insert Into #FollowUp
Exec sp_executesql @.SPName
The result is saved to a temporary table and showed to administrator. It
failed always by calling FUPCorrectStatusOfOrder – a bit complicated code but
without any “strange” statements (a couple of “subselect”s and “group by”s).
SQL server stops responding after the exception occurs.
Can you help me please?
Regards,
Martin.
Part of SQL error log:
* BEGIN STACK DUMP:
2007-06-06 11:42:30.27 spid80 * 06/06/07 11:42:30 spid 80
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 * Exception Address = 000000000100A841
Module(sqlservr+000000000000A841)
2007-06-06 11:42:30.27 spid80 * Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
2007-06-06 11:42:30.27 spid80 * Access Violation occurred reading
address 0000000000000022
2007-06-06 11:42:30.27 spid80 * Input Buffer 54 bytes -
2007-06-06 11:42:30.27 spid80 * Exec FUPDispatch
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 * MODULE BASE
END SIZE
2007-06-06 11:42:30.27 spid80 * sqlservr
0000000001000000 0000000003501FFF 02502000
2007-06-06 11:42:30.27 spid80 * ntdll
0000000078EC0000 0000000078FF8FFF 00139000
2007-06-06 11:42:30.27 spid80 * kernel32
0000000077D40000 0000000077EB2FFF 00173000
2007-06-06 11:42:30.27 spid80 * MSVCR80
0000000078130000 00000000781FEFFF 000cf000
2007-06-06 11:42:30.27 spid80 * msvcrt
000007FF7FC00000 000007FF7FC85FFF 00086000
2007-06-06 11:42:30.27 spid80 * MSVCP80
000000007C420000 000000007C530FFF 00111000
2007-06-06 11:42:30.27 spid80 * ADVAPI32
000007FF7FEE0000 000007FF7FFE4FFF 00105000
2007-06-06 11:42:30.27 spid80 * RPCRT4
000007FF7FD30000 000007FF7FED8FFF 001a9000
2007-06-06 11:42:30.27 spid80 * USER32
0000000078C30000 0000000078D3BFFF 0010c000
2007-06-06 11:42:30.27 spid80 * GDI32
000007FF7FC90000 000007FF7FD28FFF 00099000
2007-06-06 11:42:30.27 spid80 * CRYPT32
000007FF7D180000 000007FF7D2DEFFF 0015f000
2007-06-06 11:42:30.27 spid80 * MSASN1
000007FF7D150000 000007FF7D179FFF 0002a000
2007-06-06 11:42:30.27 spid80 * Secur32
000007FF7E7F0000 000007FF7E811FFF 00022000
2007-06-06 11:42:30.27 spid80 * MSWSOCK
000007FF76FE0000 000007FF7705BFFF 0007c000
2007-06-06 11:42:30.27 spid80 * WS2_32
000007FF77150000 000007FF7717FFFF 00030000
2007-06-06 11:42:30.27 spid80 * WS2HELP
000007FF77140000 000007FF7714BFFF 0000c000
2007-06-06 11:42:30.27 spid80 * USERENV
000007FF7C4A0000 000007FF7C5A8FFF 00109000
2007-06-06 11:42:30.27 spid80 * opends60
00000000333E0000 00000000333E7FFF 00008000
2007-06-06 11:42:30.27 spid80 * NETAPI32
000007FF77370000 000007FF77407FFF 00098000
2007-06-06 11:42:30.27 spid80 * SHELL32
000007FF7F190000 000007FF7FB97FFF 00a08000
2007-06-06 11:42:30.27 spid80 * SHLWAPI
000007FF7EF60000 000007FF7EFFAFFF 0009b000
2007-06-06 11:42:30.27 spid80 * IMM32
000007FF7D320000 000007FF7D358FFF 00039000
2007-06-06 11:42:30.27 spid80 * comctl32
000007FF7F000000 000007FF7F186FFF 00187000
2007-06-06 11:42:30.27 spid80 * psapi
000007FF7E1B0000 000007FF7E1BFFFF 00010000
2007-06-06 11:42:30.27 spid80 * instapi
0000000048060000 000000004806CFFF 0000d000
2007-06-06 11:42:30.27 spid80 * sqlevn70
000000004F610000 000000004F7B8FFF 001a9000
2007-06-06 11:42:30.27 spid80 * SQLOS
00000000344D0000 00000000344D5FFF 00006000
2007-06-06 11:42:30.27 spid80 * rsaenh
000000000FFB0000 000000000FFEDFFF 0003e000
2007-06-06 11:42:30.27 spid80 * AUTHZ
000007FF7E2C0000 000007FF7E2ECFFF 0002d000
2007-06-06 11:42:30.27 spid80 * MSCOREE
000006427EE60000 000006427EED3FFF 00074000
2007-06-06 11:42:30.27 spid80 * ole32
000007FF7ECE0000 000007FF7EF51FFF 00272000
2007-06-06 11:42:30.27 spid80 * msv1_0
000007FF7E330000 000007FF7E373FFF 00044000
2007-06-06 11:42:30.27 spid80 * iphlpapi
000007FF57250000 000007FF57280FFF 00031000
2007-06-06 11:42:30.27 spid80 * kerberos
000007FF77410000 000007FF774C2FFF 000b3000
2007-06-06 11:42:30.27 spid80 * cryptdll
000007FF7DAB0000 000007FF7DABEFFF 0000f000
2007-06-06 11:42:30.27 spid80 * schannel
000007FF7DB70000 000007FF7DBB0FFF 00041000
2007-06-06 11:42:30.27 spid80 * COMRES
000007FF7E920000 000007FF7E9E5FFF 000c6000
2007-06-06 11:42:30.27 spid80 * XOLEHLP
000007FF5C560000 000007FF5C566FFF 00007000
2007-06-06 11:42:30.27 spid80 * MSDTCPRX
000007FF67140000 000007FF67210FFF 000d1000
2007-06-06 11:42:30.27 spid80 * msvcp60
0000000008340000 0000000008429FFF 000ea000
2007-06-06 11:42:30.27 spid80 * MTXCLU
000007FF7B540000 000007FF7B569FFF 0002a000
2007-06-06 11:42:30.27 spid80 * VERSION
000007FF7FBF0000 000007FF7FBFAFFF 0000b000
2007-06-06 11:42:30.27 spid80 * WSOCK32
000007FF770F0000 000007FF770F9FFF 0000a000
2007-06-06 11:42:30.27 spid80 * OLEAUT32
000007FF7E9F0000 000007FF7EB03FFF 00114000
2007-06-06 11:42:30.27 spid80 * CLUSAPI
000007FF7B1C0000 000007FF7B1E3FFF 00024000
2007-06-06 11:42:30.27 spid80 * RESUTILS
000007FF7B310000 000007FF7B32BFFF 0001c000
2007-06-06 11:42:30.27 spid80 * DNSAPI
0000000008440000 000000000848DFFF 0004e000
2007-06-06 11:42:30.27 spid80 * winrnr
000007FF7E820000 000007FF7E82AFFF 0000b000
2007-06-06 11:42:30.27 spid80 * WLDAP32
000007FF7E780000 000007FF7E7E5FFF 00066000
2007-06-06 11:42:30.27 spid80 * rasadhlp
0000000008530000 0000000008536FFF 00007000
2007-06-06 11:42:30.27 spid80 * security
000007FF77530000 000007FF77534FFF 00005000
2007-06-06 11:42:30.27 spid80 * msfte
0000000049980000 0000000049D2DFFF 003ae000
2007-06-06 11:42:30.27 spid80 * dbghelp
000000000A530000 000000000A68CFFF 0015d000
2007-06-06 11:42:30.27 spid80 * WINTRUST
000007FF7E210000 000007FF7E25DFFF 0004e000
2007-06-06 11:42:30.27 spid80 * imagehlp
000007FF7E2A0000 000007FF7E2B2FFF 00013000
2007-06-06 11:42:30.27 spid80 * dssenh
000000000FF70000 000000000FFABFFF 0003c000
2007-06-06 11:42:30.27 spid80 * hnetcfg
000007FF6D1F0000 000007FF6D280FFF 00091000
2007-06-06 11:42:30.27 spid80 * wshtcpip
000007FF76FA0000 000007FF76FAAFFF 0000b000
2007-06-06 11:42:30.27 spid80 * NTMARTA
000007FF7E2F0000 000007FF7E32BFFF 0003c000
2007-06-06 11:42:30.27 spid80 * SAMLIB
000007FF76F80000 000007FF76F95FFF 00016000
2007-06-06 11:42:30.27 spid80 * ntdsapi
000007FF7DAD0000 000007FF7DAF3FFF 00024000
2007-06-06 11:42:30.27 spid80 * xpsp2res
000007FF5C210000 000007FF5C4D6FFF 002c7000
2007-06-06 11:42:30.27 spid80 * CLBCatQ
0000000003510000 00000000035ECFFF 000dd000
2007-06-06 11:42:30.27 spid80 * sqlncli
00000000337A0000 0000000033A5FFFF 002c0000
2007-06-06 11:42:30.27 spid80 * COMCTL32
000007FF76200000 000007FF762EDFFF 000ee000
2007-06-06 11:42:30.27 spid80 * comdlg32
000007FF7D360000 000007FF7D3D6FFF 00077000
2007-06-06 11:42:30.27 spid80 * SQLNCLIR
0000000035000000 0000000035032FFF 00033000
2007-06-06 11:42:30.27 spid80 * msftepxy
0000000003680000 00000000036A0FFF 00021000
2007-06-06 11:42:30.27 spid80 * xpsqlbot
000000004A7C0000 000000004A7C7FFF 00008000
2007-06-06 11:42:30.27 spid80 * xpstar90
0000000053C30000 0000000053CB5FFF 00086000
2007-06-06 11:42:30.27 spid80 * SQLSCM90
0000000053AD0000 0000000053ADBFFF 0000c000
2007-06-06 11:42:30.27 spid80 * ODBC32
000007FF63EB0000 000007FF63F16FFF 00067000
2007-06-06 11:42:30.27 spid80 * BatchParser90
00000000520C0000 00000000520ECFFF 0002d000
2007-06-06 11:42:30.27 spid80 * ATL80
000000007C630000 000000007C64DFFF 0001e000
2007-06-06 11:42:30.27 spid80 * odbcint
000007FF63DC0000 000007FF63DD7FFF 00018000
2007-06-06 11:42:30.27 spid80 * xpstar90
000000000E0A0000 000000000E0C5FFF 00026000
2007-06-06 11:42:30.27 spid80 * xplog70
0000000034730000 000000003473FFFF 00010000
2007-06-06 11:42:30.27 spid80 * xplog70
000000000E0E0000 000000000E0E2FFF 00003000
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 * P1Home: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * P2Home: 000000000F9DEA00:
0000000000000000 000000000F9DEA00 00000000A111CB80 000000000F9DEFE0
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * P3Home: 00000000A111CB80:
0000000000000000 00000000A111CAC8 0000000000000000 0000000000000000
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * P4Home: 000000000F9DEFE0:
00000000B094C6D0 00000000011AF745 FF01FFFFFFFFFFFE 0000000001004A74
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * P5Home: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * P6Home: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * ContextFlags: 000000000010001F:
2007-06-06 11:42:30.27 spid80 * MxCsr: 0000000000001FA0:
2007-06-06 11:42:30.27 spid80 * SegCs: 0000000000000033:
2007-06-06 11:42:30.27 spid80 * SegDs: 000000000000002B:
2007-06-06 11:42:30.27 spid80 * SegEs: 000000000000002B:
2007-06-06 11:42:30.27 spid80 * SegFs: 0000000000000053:
2007-06-06 11:42:30.27 spid80 * SegGs: 000000000000002B:
2007-06-06 11:42:30.27 spid80 * SegSs: 000000000000002B:
2007-06-06 11:42:30.27 spid80 * EFlags: 0000000000010246:
006D006100720067 006C006900460020 0053005C00730065 004D0058004C0051
002E00340020004C 00690062005C0030
2007-06-06 11:42:30.27 spid80 * Rax: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * Rcx: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * Rdx: 000000000000006F:
2007-06-06 11:42:30.27 spid80 * Rbx: 00000000A111CB80:
0000000000000000 00000000A111CAC8 0000000000000000 0000000000000000
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * Rsp: 000000000F9DEFA0:
00000000A111CB80 000000000F9DEFE0 000000000766BCD0 0000000000000000
00000000B094C730 000000000146EAEF
2007-06-06 11:42:30.27 spid80 * Rbp: 000000000F9DEFE0:
00000000B094C6D0 00000000011AF745 FF01FFFFFFFFFFFE 0000000001004A74
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * Rsi: 000000000766BCD0:
0000000000000CD4 0000000152E1AD00 0000000000000000 0000000000000000
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * Rdi: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * R8: 0000000000000015:
2007-06-06 11:42:30.27 spid80 * R9: 000007FFFFF54000:
0000000000000000 000000000F9E0000 000000000F9C5000 0000000000000000
0000000000001E00 0000000000000000
2007-06-06 11:42:30.27 spid80 * R10: 0000000000000001:
2007-06-06 11:42:30.27 spid80 * R11: 0000000000000001:
2007-06-06 11:42:30.27 spid80 * R12: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * R13: 0000000075C23F02:
2007-06-06 11:42:30.27 spid80 * R14: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * R15: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * Rip: 000000000100A841:
74C085662241B70F 41896601E8836608 7F3944663B8B4822 0F247F39440A7522
0002BF00009F0A84 247D833E89440000
2007-06-06 11:42:30.27 spid80 *
************************************************** *****************************
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 * Short Stack Dump
2007-06-06 11:42:30.32 spid80 000000000100A841
Module(sqlservr+000000000000A841)
2007-06-06 11:42:30.32 spid80 00000000011BCF36
Module(sqlservr+00000000001BCF36)
2007-06-06 11:42:30.32 spid80 00000000011BCDB2
Module(sqlservr+00000000001BCDB2)
2007-06-06 11:42:30.32 spid80 00000000010B68D3
Module(sqlservr+00000000000B68D3)
2007-06-06 11:42:30.32 spid80 0000000001021C98
Module(sqlservr+0000000000021C98)
2007-06-06 11:42:30.32 spid80 000000000171A50F
Module(sqlservr+000000000071A50F)
2007-06-06 11:42:30.32 spid80 00000000010DED5F
Module(sqlservr+00000000000DED5F)
2007-06-06 11:42:30.32 spid80 00000000010DE75B
Module(sqlservr+00000000000DE75B)
2007-06-06 11:42:30.32 spid80 000000000134C327
Module(sqlservr+000000000034C327)
2007-06-06 11:42:30.32 spid80 000000000134C2DF
Module(sqlservr+000000000034C2DF)
2007-06-06 11:42:30.32 spid80 0000000001354770
Module(sqlservr+0000000000354770)
2007-06-06 11:42:30.32 spid80 000000000134CD93
Module(sqlservr+000000000034CD93)
2007-06-06 11:42:30.32 spid80 000000000134B876
Module(sqlservr+000000000034B876)
2007-06-06 11:42:30.32 spid80 000000000100685E
Module(sqlservr+000000000000685E)
2007-06-06 11:42:30.32 spid80 0000000001006F11
Module(sqlservr+0000000000006F11)
2007-06-06 11:42:30.32 spid80 0000000001006A01
Module(sqlservr+0000000000006A01)
2007-06-06 11:42:30.32 spid80 00000000010EF7A7
Module(sqlservr+00000000000EF7A7)
2007-06-06 11:42:30.32 spid80 00000000010F051A
Module(sqlservr+00000000000F051A)
2007-06-06 11:42:30.32 spid80 00000000010F03F1
Module(sqlservr+00000000000F03F1)
2007-06-06 11:42:30.33 spid80 00000000010F0289
Module(sqlservr+00000000000F0289)
2007-06-06 11:42:30.33 spid80 00000000781337A7
Module(MSVCR80+00000000000037A7)
2007-06-06 11:42:30.33 spid80 0000000078133864
Module(MSVCR80+0000000000003864)
2007-06-06 11:42:30.35 spid80 0000000077D6B69A
Module(kernel32+000000000002B69A)
2007-06-06 11:42:30.36 spid80 Stack Signature for the dump is
0x00000001F2D1D3FC
2007-06-06 11:42:30.39 Logon Login succeeded for user
'PATRIA\Babulakova'. Connection: trusted. [CLIENT: 10.0.1.58]
2007-06-06 11:42:34.16 spid80 External dump process return code
0x20000001.
External dump process returned no errors.
Martin,
An Access Violation is a bug in SQL Server. You should report it to
Microsoft and seek their involvement.
You can also search the Knowledge Base for any access violations reports or
fixes that match your code. Or, you can post the actual code for someone to
examine.
RLF
"Martin Helmich" <Martin Helmich@.discussions.microsoft.com> wrote in message
news:ADB959ED-33B7-4FE9-9598-7F847C74D5B4@.microsoft.com...
> Hello,
> I have a serious problem with MS SQL Server 2005 version 9.00.3042.00,
> platform NT AMD64 (Windows 2003 64bit R2).
> It seems our code triggers an internal exception
> EXCEPTION_ACCESS_VIOLATION
> (see SQLDump0011.log file). It happened 5 times within last 2 months (btw
> there was SQL Server 2005 SP1 first 3 times).
> The FUPDispatch procedure is run under SQL Server Agent. It calls a couple
> of reconciliation procedures by
> Insert Into #FollowUp
> Exec sp_executesql @.SPName
> The result is saved to a temporary table and showed to administrator. It
> failed always by calling FUPCorrectStatusOfOrder - a bit complicated code
> but
> without any "strange" statements (a couple of "subselect"s and "group by"s).
> SQL server stops responding after the exception occurs.
> Can you help me please?
> Regards,
> Martin.
>
> Part of SQL error log:
> * BEGIN STACK DUMP:
> 2007-06-06 11:42:30.27 spid80 * 06/06/07 11:42:30 spid 80
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 * Exception Address =
> 000000000100A841
> Module(sqlservr+000000000000A841)
> 2007-06-06 11:42:30.27 spid80 * Exception Code = c0000005
> EXCEPTION_ACCESS_VIOLATION
> 2007-06-06 11:42:30.27 spid80 * Access Violation occurred reading
> address 0000000000000022
> 2007-06-06 11:42:30.27 spid80 * Input Buffer 54 bytes -
> 2007-06-06 11:42:30.27 spid80 * Exec FUPDispatch
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 * MODULE BASE
> END SIZE
> 2007-06-06 11:42:30.27 spid80 * sqlservr
> 0000000001000000 0000000003501FFF 02502000
> 2007-06-06 11:42:30.27 spid80 * ntdll
> 0000000078EC0000 0000000078FF8FFF 00139000
> 2007-06-06 11:42:30.27 spid80 * kernel32
> 0000000077D40000 0000000077EB2FFF 00173000
> 2007-06-06 11:42:30.27 spid80 * MSVCR80
> 0000000078130000 00000000781FEFFF 000cf000
> 2007-06-06 11:42:30.27 spid80 * msvcrt
> 000007FF7FC00000 000007FF7FC85FFF 00086000
> 2007-06-06 11:42:30.27 spid80 * MSVCP80
> 000000007C420000 000000007C530FFF 00111000
> 2007-06-06 11:42:30.27 spid80 * ADVAPI32
> 000007FF7FEE0000 000007FF7FFE4FFF 00105000
> 2007-06-06 11:42:30.27 spid80 * RPCRT4
> 000007FF7FD30000 000007FF7FED8FFF 001a9000
> 2007-06-06 11:42:30.27 spid80 * USER32
> 0000000078C30000 0000000078D3BFFF 0010c000
> 2007-06-06 11:42:30.27 spid80 * GDI32
> 000007FF7FC90000 000007FF7FD28FFF 00099000
> 2007-06-06 11:42:30.27 spid80 * CRYPT32
> 000007FF7D180000 000007FF7D2DEFFF 0015f000
> 2007-06-06 11:42:30.27 spid80 * MSASN1
> 000007FF7D150000 000007FF7D179FFF 0002a000
> 2007-06-06 11:42:30.27 spid80 * Secur32
> 000007FF7E7F0000 000007FF7E811FFF 00022000
> 2007-06-06 11:42:30.27 spid80 * MSWSOCK
> 000007FF76FE0000 000007FF7705BFFF 0007c000
> 2007-06-06 11:42:30.27 spid80 * WS2_32
> 000007FF77150000 000007FF7717FFFF 00030000
> 2007-06-06 11:42:30.27 spid80 * WS2HELP
> 000007FF77140000 000007FF7714BFFF 0000c000
> 2007-06-06 11:42:30.27 spid80 * USERENV
> 000007FF7C4A0000 000007FF7C5A8FFF 00109000
> 2007-06-06 11:42:30.27 spid80 * opends60
> 00000000333E0000 00000000333E7FFF 00008000
> 2007-06-06 11:42:30.27 spid80 * NETAPI32
> 000007FF77370000 000007FF77407FFF 00098000
> 2007-06-06 11:42:30.27 spid80 * SHELL32
> 000007FF7F190000 000007FF7FB97FFF 00a08000
> 2007-06-06 11:42:30.27 spid80 * SHLWAPI
> 000007FF7EF60000 000007FF7EFFAFFF 0009b000
> 2007-06-06 11:42:30.27 spid80 * IMM32
> 000007FF7D320000 000007FF7D358FFF 00039000
> 2007-06-06 11:42:30.27 spid80 * comctl32
> 000007FF7F000000 000007FF7F186FFF 00187000
> 2007-06-06 11:42:30.27 spid80 * psapi
> 000007FF7E1B0000 000007FF7E1BFFFF 00010000
> 2007-06-06 11:42:30.27 spid80 * instapi
> 0000000048060000 000000004806CFFF 0000d000
> 2007-06-06 11:42:30.27 spid80 * sqlevn70
> 000000004F610000 000000004F7B8FFF 001a9000
> 2007-06-06 11:42:30.27 spid80 * SQLOS
> 00000000344D0000 00000000344D5FFF 00006000
> 2007-06-06 11:42:30.27 spid80 * rsaenh
> 000000000FFB0000 000000000FFEDFFF 0003e000
> 2007-06-06 11:42:30.27 spid80 * AUTHZ
> 000007FF7E2C0000 000007FF7E2ECFFF 0002d000
> 2007-06-06 11:42:30.27 spid80 * MSCOREE
> 000006427EE60000 000006427EED3FFF 00074000
> 2007-06-06 11:42:30.27 spid80 * ole32
> 000007FF7ECE0000 000007FF7EF51FFF 00272000
> 2007-06-06 11:42:30.27 spid80 * msv1_0
> 000007FF7E330000 000007FF7E373FFF 00044000
> 2007-06-06 11:42:30.27 spid80 * iphlpapi
> 000007FF57250000 000007FF57280FFF 00031000
> 2007-06-06 11:42:30.27 spid80 * kerberos
> 000007FF77410000 000007FF774C2FFF 000b3000
> 2007-06-06 11:42:30.27 spid80 * cryptdll
> 000007FF7DAB0000 000007FF7DABEFFF 0000f000
> 2007-06-06 11:42:30.27 spid80 * schannel
> 000007FF7DB70000 000007FF7DBB0FFF 00041000
> 2007-06-06 11:42:30.27 spid80 * COMRES
> 000007FF7E920000 000007FF7E9E5FFF 000c6000
> 2007-06-06 11:42:30.27 spid80 * XOLEHLP
> 000007FF5C560000 000007FF5C566FFF 00007000
> 2007-06-06 11:42:30.27 spid80 * MSDTCPRX
> 000007FF67140000 000007FF67210FFF 000d1000
> 2007-06-06 11:42:30.27 spid80 * msvcp60
> 0000000008340000 0000000008429FFF 000ea000
> 2007-06-06 11:42:30.27 spid80 * MTXCLU
> 000007FF7B540000 000007FF7B569FFF 0002a000
> 2007-06-06 11:42:30.27 spid80 * VERSION
> 000007FF7FBF0000 000007FF7FBFAFFF 0000b000
> 2007-06-06 11:42:30.27 spid80 * WSOCK32
> 000007FF770F0000 000007FF770F9FFF 0000a000
> 2007-06-06 11:42:30.27 spid80 * OLEAUT32
> 000007FF7E9F0000 000007FF7EB03FFF 00114000
> 2007-06-06 11:42:30.27 spid80 * CLUSAPI
> 000007FF7B1C0000 000007FF7B1E3FFF 00024000
> 2007-06-06 11:42:30.27 spid80 * RESUTILS
> 000007FF7B310000 000007FF7B32BFFF 0001c000
> 2007-06-06 11:42:30.27 spid80 * DNSAPI
> 0000000008440000 000000000848DFFF 0004e000
> 2007-06-06 11:42:30.27 spid80 * winrnr
> 000007FF7E820000 000007FF7E82AFFF 0000b000
> 2007-06-06 11:42:30.27 spid80 * WLDAP32
> 000007FF7E780000 000007FF7E7E5FFF 00066000
> 2007-06-06 11:42:30.27 spid80 * rasadhlp
> 0000000008530000 0000000008536FFF 00007000
> 2007-06-06 11:42:30.27 spid80 * security
> 000007FF77530000 000007FF77534FFF 00005000
> 2007-06-06 11:42:30.27 spid80 * msfte
> 0000000049980000 0000000049D2DFFF 003ae000
> 2007-06-06 11:42:30.27 spid80 * dbghelp
> 000000000A530000 000000000A68CFFF 0015d000
> 2007-06-06 11:42:30.27 spid80 * WINTRUST
> 000007FF7E210000 000007FF7E25DFFF 0004e000
> 2007-06-06 11:42:30.27 spid80 * imagehlp
> 000007FF7E2A0000 000007FF7E2B2FFF 00013000
> 2007-06-06 11:42:30.27 spid80 * dssenh
> 000000000FF70000 000000000FFABFFF 0003c000
> 2007-06-06 11:42:30.27 spid80 * hnetcfg
> 000007FF6D1F0000 000007FF6D280FFF 00091000
> 2007-06-06 11:42:30.27 spid80 * wshtcpip
> 000007FF76FA0000 000007FF76FAAFFF 0000b000
> 2007-06-06 11:42:30.27 spid80 * NTMARTA
> 000007FF7E2F0000 000007FF7E32BFFF 0003c000
> 2007-06-06 11:42:30.27 spid80 * SAMLIB
> 000007FF76F80000 000007FF76F95FFF 00016000
> 2007-06-06 11:42:30.27 spid80 * ntdsapi
> 000007FF7DAD0000 000007FF7DAF3FFF 00024000
> 2007-06-06 11:42:30.27 spid80 * xpsp2res
> 000007FF5C210000 000007FF5C4D6FFF 002c7000
> 2007-06-06 11:42:30.27 spid80 * CLBCatQ
> 0000000003510000 00000000035ECFFF 000dd000
> 2007-06-06 11:42:30.27 spid80 * sqlncli
> 00000000337A0000 0000000033A5FFFF 002c0000
> 2007-06-06 11:42:30.27 spid80 * COMCTL32
> 000007FF76200000 000007FF762EDFFF 000ee000
> 2007-06-06 11:42:30.27 spid80 * comdlg32
> 000007FF7D360000 000007FF7D3D6FFF 00077000
> 2007-06-06 11:42:30.27 spid80 * SQLNCLIR
> 0000000035000000 0000000035032FFF 00033000
> 2007-06-06 11:42:30.27 spid80 * msftepxy
> 0000000003680000 00000000036A0FFF 00021000
> 2007-06-06 11:42:30.27 spid80 * xpsqlbot
> 000000004A7C0000 000000004A7C7FFF 00008000
> 2007-06-06 11:42:30.27 spid80 * xpstar90
> 0000000053C30000 0000000053CB5FFF 00086000
> 2007-06-06 11:42:30.27 spid80 * SQLSCM90
> 0000000053AD0000 0000000053ADBFFF 0000c000
> 2007-06-06 11:42:30.27 spid80 * ODBC32
> 000007FF63EB0000 000007FF63F16FFF 00067000
> 2007-06-06 11:42:30.27 spid80 * BatchParser90
> 00000000520C0000 00000000520ECFFF 0002d000
> 2007-06-06 11:42:30.27 spid80 * ATL80
> 000000007C630000 000000007C64DFFF 0001e000
> 2007-06-06 11:42:30.27 spid80 * odbcint
> 000007FF63DC0000 000007FF63DD7FFF 00018000
> 2007-06-06 11:42:30.27 spid80 * xpstar90
> 000000000E0A0000 000000000E0C5FFF 00026000
> 2007-06-06 11:42:30.27 spid80 * xplog70
> 0000000034730000 000000003473FFFF 00010000
> 2007-06-06 11:42:30.27 spid80 * xplog70
> 000000000E0E0000 000000000E0E2FFF 00003000
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 * P1Home: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * P2Home: 000000000F9DEA00:
> 0000000000000000 000000000F9DEA00 00000000A111CB80 000000000F9DEFE0
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * P3Home: 00000000A111CB80:
> 0000000000000000 00000000A111CAC8 0000000000000000 0000000000000000
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * P4Home: 000000000F9DEFE0:
> 00000000B094C6D0 00000000011AF745 FF01FFFFFFFFFFFE 0000000001004A74
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * P5Home: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * P6Home: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * ContextFlags: 000000000010001F:
> 2007-06-06 11:42:30.27 spid80 * MxCsr: 0000000000001FA0:
> 2007-06-06 11:42:30.27 spid80 * SegCs: 0000000000000033:
> 2007-06-06 11:42:30.27 spid80 * SegDs: 000000000000002B:
> 2007-06-06 11:42:30.27 spid80 * SegEs: 000000000000002B:
> 2007-06-06 11:42:30.27 spid80 * SegFs: 0000000000000053:
> 2007-06-06 11:42:30.27 spid80 * SegGs: 000000000000002B:
> 2007-06-06 11:42:30.27 spid80 * SegSs: 000000000000002B:
> 2007-06-06 11:42:30.27 spid80 * EFlags: 0000000000010246:
> 006D006100720067 006C006900460020 0053005C00730065 004D0058004C0051
> 002E00340020004C 00690062005C0030
> 2007-06-06 11:42:30.27 spid80 * Rax: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * Rcx: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * Rdx: 000000000000006F:
> 2007-06-06 11:42:30.27 spid80 * Rbx: 00000000A111CB80:
> 0000000000000000 00000000A111CAC8 0000000000000000 0000000000000000
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * Rsp: 000000000F9DEFA0:
> 00000000A111CB80 000000000F9DEFE0 000000000766BCD0 0000000000000000
> 00000000B094C730 000000000146EAEF
> 2007-06-06 11:42:30.27 spid80 * Rbp: 000000000F9DEFE0:
> 00000000B094C6D0 00000000011AF745 FF01FFFFFFFFFFFE 0000000001004A74
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * Rsi: 000000000766BCD0:
> 0000000000000CD4 0000000152E1AD00 0000000000000000 0000000000000000
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * Rdi: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * R8: 0000000000000015:
> 2007-06-06 11:42:30.27 spid80 * R9: 000007FFFFF54000:
> 0000000000000000 000000000F9E0000 000000000F9C5000 0000000000000000
> 0000000000001E00 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * R10: 0000000000000001:
> 2007-06-06 11:42:30.27 spid80 * R11: 0000000000000001:
> 2007-06-06 11:42:30.27 spid80 * R12: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * R13: 0000000075C23F02:
> 2007-06-06 11:42:30.27 spid80 * R14: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * R15: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * Rip: 000000000100A841:
> 74C085662241B70F 41896601E8836608 7F3944663B8B4822 0F247F39440A7522
> 0002BF00009F0A84 247D833E89440000
> 2007-06-06 11:42:30.27 spid80 *
> ************************************************** *****************************
> 2007-06-06 11:42:30.27 spid80 *
> ----
> 2007-06-06 11:42:30.27 spid80 * Short Stack Dump
> 2007-06-06 11:42:30.32 spid80 000000000100A841
> Module(sqlservr+000000000000A841)
> 2007-06-06 11:42:30.32 spid80 00000000011BCF36
> Module(sqlservr+00000000001BCF36)
> 2007-06-06 11:42:30.32 spid80 00000000011BCDB2
> Module(sqlservr+00000000001BCDB2)
> 2007-06-06 11:42:30.32 spid80 00000000010B68D3
> Module(sqlservr+00000000000B68D3)
> 2007-06-06 11:42:30.32 spid80 0000000001021C98
> Module(sqlservr+0000000000021C98)
> 2007-06-06 11:42:30.32 spid80 000000000171A50F
> Module(sqlservr+000000000071A50F)
> 2007-06-06 11:42:30.32 spid80 00000000010DED5F
> Module(sqlservr+00000000000DED5F)
> 2007-06-06 11:42:30.32 spid80 00000000010DE75B
> Module(sqlservr+00000000000DE75B)
> 2007-06-06 11:42:30.32 spid80 000000000134C327
> Module(sqlservr+000000000034C327)
> 2007-06-06 11:42:30.32 spid80 000000000134C2DF
> Module(sqlservr+000000000034C2DF)
> 2007-06-06 11:42:30.32 spid80 0000000001354770
> Module(sqlservr+0000000000354770)
> 2007-06-06 11:42:30.32 spid80 000000000134CD93
> Module(sqlservr+000000000034CD93)
> 2007-06-06 11:42:30.32 spid80 000000000134B876
> Module(sqlservr+000000000034B876)
> 2007-06-06 11:42:30.32 spid80 000000000100685E
> Module(sqlservr+000000000000685E)
> 2007-06-06 11:42:30.32 spid80 0000000001006F11
> Module(sqlservr+0000000000006F11)
> 2007-06-06 11:42:30.32 spid80 0000000001006A01
> Module(sqlservr+0000000000006A01)
> 2007-06-06 11:42:30.32 spid80 00000000010EF7A7
> Module(sqlservr+00000000000EF7A7)
> 2007-06-06 11:42:30.32 spid80 00000000010F051A
> Module(sqlservr+00000000000F051A)
> 2007-06-06 11:42:30.32 spid80 00000000010F03F1
> Module(sqlservr+00000000000F03F1)
> 2007-06-06 11:42:30.33 spid80 00000000010F0289
> Module(sqlservr+00000000000F0289)
> 2007-06-06 11:42:30.33 spid80 00000000781337A7
> Module(MSVCR80+00000000000037A7)
> 2007-06-06 11:42:30.33 spid80 0000000078133864
> Module(MSVCR80+0000000000003864)
> 2007-06-06 11:42:30.35 spid80 0000000077D6B69A
> Module(kernel32+000000000002B69A)
> 2007-06-06 11:42:30.36 spid80 Stack Signature for the dump is
> 0x00000001F2D1D3FC
> 2007-06-06 11:42:30.39 Logon Login succeeded for user
> 'PATRIA\Babulakova'. Connection: trusted. [CLIENT: 10.0.1.58]
> 2007-06-06 11:42:34.16 spid80 External dump process return code
> 0x20000001.
> External dump process returned no errors.
>

EXCEPTION_ACCESS_VIOLATION crash

Hello,
I have a serious problem with MS SQL Server 2005 version 9.00.3042.00,
platform NT AMD64 (Windows 2003 64bit R2).
It seems our code triggers an internal exception EXCEPTION_ACCESS_VIOLATION
(see SQLDump0011.log file). It happened 5 times within last 2 months (btw
there was SQL Server 2005 SP1 first 3 times).
The FUPDispatch procedure is run under SQL Server Agent. It calls a couple
of reconciliation procedures by
Insert Into #FollowUp
Exec sp_executesql @.SPName
The result is saved to a temporary table and showed to administrator. It
failed always by calling FUPCorrectStatusOfOrder – a bit complicated code
but
without any “strange” statements (a couple of “subselect”s and “gr
oup by”s).
SQL server stops responding after the exception occurs.
Can you help me please?
Regards,
Martin.
Part of SQL error log:
* BEGIN STACK DUMP:
2007-06-06 11:42:30.27 spid80 * 06/06/07 11:42:30 spid 80
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 * Exception Address = 000000000100A841
Module(sqlservr+000000000000A841)
2007-06-06 11:42:30.27 spid80 * Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
2007-06-06 11:42:30.27 spid80 * Access Violation occurred reading
address 0000000000000022
2007-06-06 11:42:30.27 spid80 * Input Buffer 54 bytes -
2007-06-06 11:42:30.27 spid80 * Exec FUPDispatch
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 * MODULE BASE
END SIZE
2007-06-06 11:42:30.27 spid80 * sqlservr
0000000001000000 0000000003501FFF 02502000
2007-06-06 11:42:30.27 spid80 * ntdll
0000000078EC0000 0000000078FF8FFF 00139000
2007-06-06 11:42:30.27 spid80 * kernel32
0000000077D40000 0000000077EB2FFF 00173000
2007-06-06 11:42:30.27 spid80 * MSVCR80
0000000078130000 00000000781FEFFF 000cf000
2007-06-06 11:42:30.27 spid80 * msvcrt
000007FF7FC00000 000007FF7FC85FFF 00086000
2007-06-06 11:42:30.27 spid80 * MSVCP80
000000007C420000 000000007C530FFF 00111000
2007-06-06 11:42:30.27 spid80 * ADVAPI32
000007FF7FEE0000 000007FF7FFE4FFF 00105000
2007-06-06 11:42:30.27 spid80 * RPCRT4
000007FF7FD30000 000007FF7FED8FFF 001a9000
2007-06-06 11:42:30.27 spid80 * USER32
0000000078C30000 0000000078D3BFFF 0010c000
2007-06-06 11:42:30.27 spid80 * GDI32
000007FF7FC90000 000007FF7FD28FFF 00099000
2007-06-06 11:42:30.27 spid80 * CRYPT32
000007FF7D180000 000007FF7D2DEFFF 0015f000
2007-06-06 11:42:30.27 spid80 * MSASN1
000007FF7D150000 000007FF7D179FFF 0002a000
2007-06-06 11:42:30.27 spid80 * Secur32
000007FF7E7F0000 000007FF7E811FFF 00022000
2007-06-06 11:42:30.27 spid80 * MSWSOCK
000007FF76FE0000 000007FF7705BFFF 0007c000
2007-06-06 11:42:30.27 spid80 * WS2_32
000007FF77150000 000007FF7717FFFF 00030000
2007-06-06 11:42:30.27 spid80 * WS2HELP
000007FF77140000 000007FF7714BFFF 0000c000
2007-06-06 11:42:30.27 spid80 * USERENV
000007FF7C4A0000 000007FF7C5A8FFF 00109000
2007-06-06 11:42:30.27 spid80 * opends60
00000000333E0000 00000000333E7FFF 00008000
2007-06-06 11:42:30.27 spid80 * NETAPI32
000007FF77370000 000007FF77407FFF 00098000
2007-06-06 11:42:30.27 spid80 * SHELL32
000007FF7F190000 000007FF7FB97FFF 00a08000
2007-06-06 11:42:30.27 spid80 * SHLWAPI
000007FF7EF60000 000007FF7EFFAFFF 0009b000
2007-06-06 11:42:30.27 spid80 * IMM32
000007FF7D320000 000007FF7D358FFF 00039000
2007-06-06 11:42:30.27 spid80 * comctl32
000007FF7F000000 000007FF7F186FFF 00187000
2007-06-06 11:42:30.27 spid80 * psapi
000007FF7E1B0000 000007FF7E1BFFFF 00010000
2007-06-06 11:42:30.27 spid80 * instapi
0000000048060000 000000004806CFFF 0000d000
2007-06-06 11:42:30.27 spid80 * sqlevn70
000000004F610000 000000004F7B8FFF 001a9000
2007-06-06 11:42:30.27 spid80 * SQLOS
00000000344D0000 00000000344D5FFF 00006000
2007-06-06 11:42:30.27 spid80 * rsaenh
000000000FFB0000 000000000FFEDFFF 0003e000
2007-06-06 11:42:30.27 spid80 * AUTHZ
000007FF7E2C0000 000007FF7E2ECFFF 0002d000
2007-06-06 11:42:30.27 spid80 * MSCOREE
000006427EE60000 000006427EED3FFF 00074000
2007-06-06 11:42:30.27 spid80 * ole32
000007FF7ECE0000 000007FF7EF51FFF 00272000
2007-06-06 11:42:30.27 spid80 * msv1_0
000007FF7E330000 000007FF7E373FFF 00044000
2007-06-06 11:42:30.27 spid80 * iphlpapi
000007FF57250000 000007FF57280FFF 00031000
2007-06-06 11:42:30.27 spid80 * kerberos
000007FF77410000 000007FF774C2FFF 000b3000
2007-06-06 11:42:30.27 spid80 * cryptdll
000007FF7DAB0000 000007FF7DABEFFF 0000f000
2007-06-06 11:42:30.27 spid80 * schannel
000007FF7DB70000 000007FF7DBB0FFF 00041000
2007-06-06 11:42:30.27 spid80 * COMRES
000007FF7E920000 000007FF7E9E5FFF 000c6000
2007-06-06 11:42:30.27 spid80 * XOLEHLP
000007FF5C560000 000007FF5C566FFF 00007000
2007-06-06 11:42:30.27 spid80 * MSDTCPRX
000007FF67140000 000007FF67210FFF 000d1000
2007-06-06 11:42:30.27 spid80 * msvcp60
0000000008340000 0000000008429FFF 000ea000
2007-06-06 11:42:30.27 spid80 * MTXCLU
000007FF7B540000 000007FF7B569FFF 0002a000
2007-06-06 11:42:30.27 spid80 * VERSION
000007FF7FBF0000 000007FF7FBFAFFF 0000b000
2007-06-06 11:42:30.27 spid80 * WSOCK32
000007FF770F0000 000007FF770F9FFF 0000a000
2007-06-06 11:42:30.27 spid80 * OLEAUT32
000007FF7E9F0000 000007FF7EB03FFF 00114000
2007-06-06 11:42:30.27 spid80 * CLUSAPI
000007FF7B1C0000 000007FF7B1E3FFF 00024000
2007-06-06 11:42:30.27 spid80 * RESUTILS
000007FF7B310000 000007FF7B32BFFF 0001c000
2007-06-06 11:42:30.27 spid80 * DNSAPI
0000000008440000 000000000848DFFF 0004e000
2007-06-06 11:42:30.27 spid80 * winrnr
000007FF7E820000 000007FF7E82AFFF 0000b000
2007-06-06 11:42:30.27 spid80 * WLDAP32
000007FF7E780000 000007FF7E7E5FFF 00066000
2007-06-06 11:42:30.27 spid80 * rasadhlp
0000000008530000 0000000008536FFF 00007000
2007-06-06 11:42:30.27 spid80 * security
000007FF77530000 000007FF77534FFF 00005000
2007-06-06 11:42:30.27 spid80 * msfte
0000000049980000 0000000049D2DFFF 003ae000
2007-06-06 11:42:30.27 spid80 * dbghelp
000000000A530000 000000000A68CFFF 0015d000
2007-06-06 11:42:30.27 spid80 * WINTRUST
000007FF7E210000 000007FF7E25DFFF 0004e000
2007-06-06 11:42:30.27 spid80 * imagehlp
000007FF7E2A0000 000007FF7E2B2FFF 00013000
2007-06-06 11:42:30.27 spid80 * dssenh
000000000FF70000 000000000FFABFFF 0003c000
2007-06-06 11:42:30.27 spid80 * hnetcfg
000007FF6D1F0000 000007FF6D280FFF 00091000
2007-06-06 11:42:30.27 spid80 * wshtcpip
000007FF76FA0000 000007FF76FAAFFF 0000b000
2007-06-06 11:42:30.27 spid80 * NTMARTA
000007FF7E2F0000 000007FF7E32BFFF 0003c000
2007-06-06 11:42:30.27 spid80 * SAMLIB
000007FF76F80000 000007FF76F95FFF 00016000
2007-06-06 11:42:30.27 spid80 * ntdsapi
000007FF7DAD0000 000007FF7DAF3FFF 00024000
2007-06-06 11:42:30.27 spid80 * xpsp2res
000007FF5C210000 000007FF5C4D6FFF 002c7000
2007-06-06 11:42:30.27 spid80 * CLBCatQ
0000000003510000 00000000035ECFFF 000dd000
2007-06-06 11:42:30.27 spid80 * sqlncli
00000000337A0000 0000000033A5FFFF 002c0000
2007-06-06 11:42:30.27 spid80 * COMCTL32
000007FF76200000 000007FF762EDFFF 000ee000
2007-06-06 11:42:30.27 spid80 * comdlg32
000007FF7D360000 000007FF7D3D6FFF 00077000
2007-06-06 11:42:30.27 spid80 * SQLNCLIR
0000000035000000 0000000035032FFF 00033000
2007-06-06 11:42:30.27 spid80 * msftepxy
0000000003680000 00000000036A0FFF 00021000
2007-06-06 11:42:30.27 spid80 * xpsqlbot
000000004A7C0000 000000004A7C7FFF 00008000
2007-06-06 11:42:30.27 spid80 * xpstar90
0000000053C30000 0000000053CB5FFF 00086000
2007-06-06 11:42:30.27 spid80 * SQLSCM90
0000000053AD0000 0000000053ADBFFF 0000c000
2007-06-06 11:42:30.27 spid80 * ODBC32
000007FF63EB0000 000007FF63F16FFF 00067000
2007-06-06 11:42:30.27 spid80 * BatchParser90
00000000520C0000 00000000520ECFFF 0002d000
2007-06-06 11:42:30.27 spid80 * ATL80
000000007C630000 000000007C64DFFF 0001e000
2007-06-06 11:42:30.27 spid80 * odbcint
000007FF63DC0000 000007FF63DD7FFF 00018000
2007-06-06 11:42:30.27 spid80 * xpstar90
000000000E0A0000 000000000E0C5FFF 00026000
2007-06-06 11:42:30.27 spid80 * xplog70
0000000034730000 000000003473FFFF 00010000
2007-06-06 11:42:30.27 spid80 * xplog70
000000000E0E0000 000000000E0E2FFF 00003000
2007-06-06 11:42:30.27 spid80 *
2007-06-06 11:42:30.27 spid80 * P1Home: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * P2Home: 000000000F9DEA00:
0000000000000000 000000000F9DEA00 00000000A111CB80 000000000F9DEFE0
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * P3Home: 00000000A111CB80:
0000000000000000 00000000A111CAC8 0000000000000000 0000000000000000
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * P4Home: 000000000F9DEFE0:
00000000B094C6D0 00000000011AF745 FF01FFFFFFFFFFFE 0000000001004A74
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * P5Home: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * P6Home: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * ContextFlags: 000000000010001F:
2007-06-06 11:42:30.27 spid80 * MxCsr: 0000000000001FA0:
2007-06-06 11:42:30.27 spid80 * SegCs: 0000000000000033:
2007-06-06 11:42:30.27 spid80 * SegDs: 000000000000002B:
2007-06-06 11:42:30.27 spid80 * SegEs: 000000000000002B:
2007-06-06 11:42:30.27 spid80 * SegFs: 0000000000000053:
2007-06-06 11:42:30.27 spid80 * SegGs: 000000000000002B:
2007-06-06 11:42:30.27 spid80 * SegSs: 000000000000002B:
2007-06-06 11:42:30.27 spid80 * EFlags: 0000000000010246:
006D006100720067 006C006900460020 0053005C00730065 004D0058004C0051
002E00340020004C 00690062005C0030
2007-06-06 11:42:30.27 spid80 * Rax: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * Rcx: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * Rdx: 000000000000006F:
2007-06-06 11:42:30.27 spid80 * Rbx: 00000000A111CB80:
0000000000000000 00000000A111CAC8 0000000000000000 0000000000000000
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * Rsp: 000000000F9DEFA0:
00000000A111CB80 000000000F9DEFE0 000000000766BCD0 0000000000000000
00000000B094C730 000000000146EAEF
2007-06-06 11:42:30.27 spid80 * Rbp: 000000000F9DEFE0:
00000000B094C6D0 00000000011AF745 FF01FFFFFFFFFFFE 0000000001004A74
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * Rsi: 000000000766BCD0:
0000000000000CD4 0000000152E1AD00 0000000000000000 0000000000000000
0000000000000000 0000000000000000
2007-06-06 11:42:30.27 spid80 * Rdi: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * R8: 0000000000000015:
2007-06-06 11:42:30.27 spid80 * R9: 000007FFFFF54000:
0000000000000000 000000000F9E0000 000000000F9C5000 0000000000000000
0000000000001E00 0000000000000000
2007-06-06 11:42:30.27 spid80 * R10: 0000000000000001:
2007-06-06 11:42:30.27 spid80 * R11: 0000000000000001:
2007-06-06 11:42:30.27 spid80 * R12: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * R13: 0000000075C23F02:
2007-06-06 11:42:30.27 spid80 * R14: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * R15: 0000000000000000:
2007-06-06 11:42:30.27 spid80 * Rip: 000000000100A841:
74C085662241B70F 41896601E8836608 7F3944663B8B4822 0F247F39440A7522
0002BF00009F0A84 247D833E89440000
2007-06-06 11:42:30.27 spid80 *
****************************************
************************************
***
2007-06-06 11:42:30.27 spid80 *
----
--
2007-06-06 11:42:30.27 spid80 * Short Stack Dump
2007-06-06 11:42:30.32 spid80 000000000100A841
Module(sqlservr+000000000000A841)
2007-06-06 11:42:30.32 spid80 00000000011BCF36
Module(sqlservr+00000000001BCF36)
2007-06-06 11:42:30.32 spid80 00000000011BCDB2
Module(sqlservr+00000000001BCDB2)
2007-06-06 11:42:30.32 spid80 00000000010B68D3
Module(sqlservr+00000000000B68D3)
2007-06-06 11:42:30.32 spid80 0000000001021C98
Module(sqlservr+0000000000021C98)
2007-06-06 11:42:30.32 spid80 000000000171A50F
Module(sqlservr+000000000071A50F)
2007-06-06 11:42:30.32 spid80 00000000010DED5F
Module(sqlservr+00000000000DED5F)
2007-06-06 11:42:30.32 spid80 00000000010DE75B
Module(sqlservr+00000000000DE75B)
2007-06-06 11:42:30.32 spid80 000000000134C327
Module(sqlservr+000000000034C327)
2007-06-06 11:42:30.32 spid80 000000000134C2DF
Module(sqlservr+000000000034C2DF)
2007-06-06 11:42:30.32 spid80 0000000001354770
Module(sqlservr+0000000000354770)
2007-06-06 11:42:30.32 spid80 000000000134CD93
Module(sqlservr+000000000034CD93)
2007-06-06 11:42:30.32 spid80 000000000134B876
Module(sqlservr+000000000034B876)
2007-06-06 11:42:30.32 spid80 000000000100685E
Module(sqlservr+000000000000685E)
2007-06-06 11:42:30.32 spid80 0000000001006F11
Module(sqlservr+0000000000006F11)
2007-06-06 11:42:30.32 spid80 0000000001006A01
Module(sqlservr+0000000000006A01)
2007-06-06 11:42:30.32 spid80 00000000010EF7A7
Module(sqlservr+00000000000EF7A7)
2007-06-06 11:42:30.32 spid80 00000000010F051A
Module(sqlservr+00000000000F051A)
2007-06-06 11:42:30.32 spid80 00000000010F03F1
Module(sqlservr+00000000000F03F1)
2007-06-06 11:42:30.33 spid80 00000000010F0289
Module(sqlservr+00000000000F0289)
2007-06-06 11:42:30.33 spid80 00000000781337A7
Module(MSVCR80+00000000000037A7)
2007-06-06 11:42:30.33 spid80 0000000078133864
Module(MSVCR80+0000000000003864)
2007-06-06 11:42:30.35 spid80 0000000077D6B69A
Module(kernel32+000000000002B69A)
2007-06-06 11:42:30.36 spid80 Stack Signature for the dump is
0x00000001F2D1D3FC
2007-06-06 11:42:30.39 Logon Login succeeded for user
'PATRIA\Babulakova'. Connection: trusted. [CLIENT: 10.0.1.58]
2007-06-06 11:42:34.16 spid80 External dump process return code
0x20000001.
External dump process returned no errors.Martin,
An Access Violation is a bug in SQL Server. You should report it to
Microsoft and seek their involvement.
You can also search the Knowledge Base for any access violations reports or
fixes that match your code. Or, you can post the actual code for someone to
examine.
RLF
"Martin Helmich" <Martin Helmich@.discussions.microsoft.com> wrote in message
news:ADB959ED-33B7-4FE9-9598-7F847C74D5B4@.microsoft.com...
> Hello,
> I have a serious problem with MS SQL Server 2005 version 9.00.3042.00,
> platform NT AMD64 (Windows 2003 64bit R2).
> It seems our code triggers an internal exception
> EXCEPTION_ACCESS_VIOLATION
> (see SQLDump0011.log file). It happened 5 times within last 2 months (btw
> there was SQL Server 2005 SP1 first 3 times).
> The FUPDispatch procedure is run under SQL Server Agent. It calls a couple
> of reconciliation procedures by
> Insert Into #FollowUp
> Exec sp_executesql @.SPName
> The result is saved to a temporary table and showed to administrator. It
> failed always by calling FUPCorrectStatusOfOrder - a bit complicated code
> but
> without any "strange" statements (a couple of "subselect"s and "group by"s
).
> SQL server stops responding after the exception occurs.
> Can you help me please?
> Regards,
> Martin.
>
> Part of SQL error log:
> * BEGIN STACK DUMP:
> 2007-06-06 11:42:30.27 spid80 * 06/06/07 11:42:30 spid 80
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 * Exception Address =
> 000000000100A841
> Module(sqlservr+000000000000A841)
> 2007-06-06 11:42:30.27 spid80 * Exception Code = c0000005
> EXCEPTION_ACCESS_VIOLATION
> 2007-06-06 11:42:30.27 spid80 * Access Violation occurred reading
> address 0000000000000022
> 2007-06-06 11:42:30.27 spid80 * Input Buffer 54 bytes -
> 2007-06-06 11:42:30.27 spid80 * Exec FUPDispatch
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 * MODULE BASE
> END SIZE
> 2007-06-06 11:42:30.27 spid80 * sqlservr
> 0000000001000000 0000000003501FFF 02502000
> 2007-06-06 11:42:30.27 spid80 * ntdll
> 0000000078EC0000 0000000078FF8FFF 00139000
> 2007-06-06 11:42:30.27 spid80 * kernel32
> 0000000077D40000 0000000077EB2FFF 00173000
> 2007-06-06 11:42:30.27 spid80 * MSVCR80
> 0000000078130000 00000000781FEFFF 000cf000
> 2007-06-06 11:42:30.27 spid80 * msvcrt
> 000007FF7FC00000 000007FF7FC85FFF 00086000
> 2007-06-06 11:42:30.27 spid80 * MSVCP80
> 000000007C420000 000000007C530FFF 00111000
> 2007-06-06 11:42:30.27 spid80 * ADVAPI32
> 000007FF7FEE0000 000007FF7FFE4FFF 00105000
> 2007-06-06 11:42:30.27 spid80 * RPCRT4
> 000007FF7FD30000 000007FF7FED8FFF 001a9000
> 2007-06-06 11:42:30.27 spid80 * USER32
> 0000000078C30000 0000000078D3BFFF 0010c000
> 2007-06-06 11:42:30.27 spid80 * GDI32
> 000007FF7FC90000 000007FF7FD28FFF 00099000
> 2007-06-06 11:42:30.27 spid80 * CRYPT32
> 000007FF7D180000 000007FF7D2DEFFF 0015f000
> 2007-06-06 11:42:30.27 spid80 * MSASN1
> 000007FF7D150000 000007FF7D179FFF 0002a000
> 2007-06-06 11:42:30.27 spid80 * Secur32
> 000007FF7E7F0000 000007FF7E811FFF 00022000
> 2007-06-06 11:42:30.27 spid80 * MSWSOCK
> 000007FF76FE0000 000007FF7705BFFF 0007c000
> 2007-06-06 11:42:30.27 spid80 * WS2_32
> 000007FF77150000 000007FF7717FFFF 00030000
> 2007-06-06 11:42:30.27 spid80 * WS2HELP
> 000007FF77140000 000007FF7714BFFF 0000c000
> 2007-06-06 11:42:30.27 spid80 * USERENV
> 000007FF7C4A0000 000007FF7C5A8FFF 00109000
> 2007-06-06 11:42:30.27 spid80 * opends60
> 00000000333E0000 00000000333E7FFF 00008000
> 2007-06-06 11:42:30.27 spid80 * NETAPI32
> 000007FF77370000 000007FF77407FFF 00098000
> 2007-06-06 11:42:30.27 spid80 * SHELL32
> 000007FF7F190000 000007FF7FB97FFF 00a08000
> 2007-06-06 11:42:30.27 spid80 * SHLWAPI
> 000007FF7EF60000 000007FF7EFFAFFF 0009b000
> 2007-06-06 11:42:30.27 spid80 * IMM32
> 000007FF7D320000 000007FF7D358FFF 00039000
> 2007-06-06 11:42:30.27 spid80 * comctl32
> 000007FF7F000000 000007FF7F186FFF 00187000
> 2007-06-06 11:42:30.27 spid80 * psapi
> 000007FF7E1B0000 000007FF7E1BFFFF 00010000
> 2007-06-06 11:42:30.27 spid80 * instapi
> 0000000048060000 000000004806CFFF 0000d000
> 2007-06-06 11:42:30.27 spid80 * sqlevn70
> 000000004F610000 000000004F7B8FFF 001a9000
> 2007-06-06 11:42:30.27 spid80 * SQLOS
> 00000000344D0000 00000000344D5FFF 00006000
> 2007-06-06 11:42:30.27 spid80 * rsaenh
> 000000000FFB0000 000000000FFEDFFF 0003e000
> 2007-06-06 11:42:30.27 spid80 * AUTHZ
> 000007FF7E2C0000 000007FF7E2ECFFF 0002d000
> 2007-06-06 11:42:30.27 spid80 * MSCOREE
> 000006427EE60000 000006427EED3FFF 00074000
> 2007-06-06 11:42:30.27 spid80 * ole32
> 000007FF7ECE0000 000007FF7EF51FFF 00272000
> 2007-06-06 11:42:30.27 spid80 * msv1_0
> 000007FF7E330000 000007FF7E373FFF 00044000
> 2007-06-06 11:42:30.27 spid80 * iphlpapi
> 000007FF57250000 000007FF57280FFF 00031000
> 2007-06-06 11:42:30.27 spid80 * kerberos
> 000007FF77410000 000007FF774C2FFF 000b3000
> 2007-06-06 11:42:30.27 spid80 * cryptdll
> 000007FF7DAB0000 000007FF7DABEFFF 0000f000
> 2007-06-06 11:42:30.27 spid80 * schannel
> 000007FF7DB70000 000007FF7DBB0FFF 00041000
> 2007-06-06 11:42:30.27 spid80 * COMRES
> 000007FF7E920000 000007FF7E9E5FFF 000c6000
> 2007-06-06 11:42:30.27 spid80 * XOLEHLP
> 000007FF5C560000 000007FF5C566FFF 00007000
> 2007-06-06 11:42:30.27 spid80 * MSDTCPRX
> 000007FF67140000 000007FF67210FFF 000d1000
> 2007-06-06 11:42:30.27 spid80 * msvcp60
> 0000000008340000 0000000008429FFF 000ea000
> 2007-06-06 11:42:30.27 spid80 * MTXCLU
> 000007FF7B540000 000007FF7B569FFF 0002a000
> 2007-06-06 11:42:30.27 spid80 * VERSION
> 000007FF7FBF0000 000007FF7FBFAFFF 0000b000
> 2007-06-06 11:42:30.27 spid80 * WSOCK32
> 000007FF770F0000 000007FF770F9FFF 0000a000
> 2007-06-06 11:42:30.27 spid80 * OLEAUT32
> 000007FF7E9F0000 000007FF7EB03FFF 00114000
> 2007-06-06 11:42:30.27 spid80 * CLUSAPI
> 000007FF7B1C0000 000007FF7B1E3FFF 00024000
> 2007-06-06 11:42:30.27 spid80 * RESUTILS
> 000007FF7B310000 000007FF7B32BFFF 0001c000
> 2007-06-06 11:42:30.27 spid80 * DNSAPI
> 0000000008440000 000000000848DFFF 0004e000
> 2007-06-06 11:42:30.27 spid80 * winrnr
> 000007FF7E820000 000007FF7E82AFFF 0000b000
> 2007-06-06 11:42:30.27 spid80 * WLDAP32
> 000007FF7E780000 000007FF7E7E5FFF 00066000
> 2007-06-06 11:42:30.27 spid80 * rasadhlp
> 0000000008530000 0000000008536FFF 00007000
> 2007-06-06 11:42:30.27 spid80 * security
> 000007FF77530000 000007FF77534FFF 00005000
> 2007-06-06 11:42:30.27 spid80 * msfte
> 0000000049980000 0000000049D2DFFF 003ae000
> 2007-06-06 11:42:30.27 spid80 * dbghelp
> 000000000A530000 000000000A68CFFF 0015d000
> 2007-06-06 11:42:30.27 spid80 * WINTRUST
> 000007FF7E210000 000007FF7E25DFFF 0004e000
> 2007-06-06 11:42:30.27 spid80 * imagehlp
> 000007FF7E2A0000 000007FF7E2B2FFF 00013000
> 2007-06-06 11:42:30.27 spid80 * dssenh
> 000000000FF70000 000000000FFABFFF 0003c000
> 2007-06-06 11:42:30.27 spid80 * hnetcfg
> 000007FF6D1F0000 000007FF6D280FFF 00091000
> 2007-06-06 11:42:30.27 spid80 * wshtcpip
> 000007FF76FA0000 000007FF76FAAFFF 0000b000
> 2007-06-06 11:42:30.27 spid80 * NTMARTA
> 000007FF7E2F0000 000007FF7E32BFFF 0003c000
> 2007-06-06 11:42:30.27 spid80 * SAMLIB
> 000007FF76F80000 000007FF76F95FFF 00016000
> 2007-06-06 11:42:30.27 spid80 * ntdsapi
> 000007FF7DAD0000 000007FF7DAF3FFF 00024000
> 2007-06-06 11:42:30.27 spid80 * xpsp2res
> 000007FF5C210000 000007FF5C4D6FFF 002c7000
> 2007-06-06 11:42:30.27 spid80 * CLBCatQ
> 0000000003510000 00000000035ECFFF 000dd000
> 2007-06-06 11:42:30.27 spid80 * sqlncli
> 00000000337A0000 0000000033A5FFFF 002c0000
> 2007-06-06 11:42:30.27 spid80 * COMCTL32
> 000007FF76200000 000007FF762EDFFF 000ee000
> 2007-06-06 11:42:30.27 spid80 * comdlg32
> 000007FF7D360000 000007FF7D3D6FFF 00077000
> 2007-06-06 11:42:30.27 spid80 * SQLNCLIR
> 0000000035000000 0000000035032FFF 00033000
> 2007-06-06 11:42:30.27 spid80 * msftepxy
> 0000000003680000 00000000036A0FFF 00021000
> 2007-06-06 11:42:30.27 spid80 * xpsqlbot
> 000000004A7C0000 000000004A7C7FFF 00008000
> 2007-06-06 11:42:30.27 spid80 * xpstar90
> 0000000053C30000 0000000053CB5FFF 00086000
> 2007-06-06 11:42:30.27 spid80 * SQLSCM90
> 0000000053AD0000 0000000053ADBFFF 0000c000
> 2007-06-06 11:42:30.27 spid80 * ODBC32
> 000007FF63EB0000 000007FF63F16FFF 00067000
> 2007-06-06 11:42:30.27 spid80 * BatchParser90
> 00000000520C0000 00000000520ECFFF 0002d000
> 2007-06-06 11:42:30.27 spid80 * ATL80
> 000000007C630000 000000007C64DFFF 0001e000
> 2007-06-06 11:42:30.27 spid80 * odbcint
> 000007FF63DC0000 000007FF63DD7FFF 00018000
> 2007-06-06 11:42:30.27 spid80 * xpstar90
> 000000000E0A0000 000000000E0C5FFF 00026000
> 2007-06-06 11:42:30.27 spid80 * xplog70
> 0000000034730000 000000003473FFFF 00010000
> 2007-06-06 11:42:30.27 spid80 * xplog70
> 000000000E0E0000 000000000E0E2FFF 00003000
> 2007-06-06 11:42:30.27 spid80 *
> 2007-06-06 11:42:30.27 spid80 * P1Home: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * P2Home: 000000000F9DEA00:
> 0000000000000000 000000000F9DEA00 00000000A111CB80 000000000F9DEFE0
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * P3Home: 00000000A111CB80:
> 0000000000000000 00000000A111CAC8 0000000000000000 0000000000000000
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * P4Home: 000000000F9DEFE0:
> 00000000B094C6D0 00000000011AF745 FF01FFFFFFFFFFFE 0000000001004A74
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * P5Home: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * P6Home: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * ContextFlags: 000000000010001F:
> 2007-06-06 11:42:30.27 spid80 * MxCsr: 0000000000001FA0:
> 2007-06-06 11:42:30.27 spid80 * SegCs: 0000000000000033:
> 2007-06-06 11:42:30.27 spid80 * SegDs: 000000000000002B:
> 2007-06-06 11:42:30.27 spid80 * SegEs: 000000000000002B:
> 2007-06-06 11:42:30.27 spid80 * SegFs: 0000000000000053:
> 2007-06-06 11:42:30.27 spid80 * SegGs: 000000000000002B:
> 2007-06-06 11:42:30.27 spid80 * SegSs: 000000000000002B:
> 2007-06-06 11:42:30.27 spid80 * EFlags: 0000000000010246:
> 006D006100720067 006C006900460020 0053005C00730065 004D0058004C0051
> 002E00340020004C 00690062005C0030
> 2007-06-06 11:42:30.27 spid80 * Rax: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * Rcx: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * Rdx: 000000000000006F:
> 2007-06-06 11:42:30.27 spid80 * Rbx: 00000000A111CB80:
> 0000000000000000 00000000A111CAC8 0000000000000000 0000000000000000
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * Rsp: 000000000F9DEFA0:
> 00000000A111CB80 000000000F9DEFE0 000000000766BCD0 0000000000000000
> 00000000B094C730 000000000146EAEF
> 2007-06-06 11:42:30.27 spid80 * Rbp: 000000000F9DEFE0:
> 00000000B094C6D0 00000000011AF745 FF01FFFFFFFFFFFE 0000000001004A74
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * Rsi: 000000000766BCD0:
> 0000000000000CD4 0000000152E1AD00 0000000000000000 0000000000000000
> 0000000000000000 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * Rdi: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * R8: 0000000000000015:
> 2007-06-06 11:42:30.27 spid80 * R9: 000007FFFFF54000:
> 0000000000000000 000000000F9E0000 000000000F9C5000 0000000000000000
> 0000000000001E00 0000000000000000
> 2007-06-06 11:42:30.27 spid80 * R10: 0000000000000001:
> 2007-06-06 11:42:30.27 spid80 * R11: 0000000000000001:
> 2007-06-06 11:42:30.27 spid80 * R12: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * R13: 0000000075C23F02:
> 2007-06-06 11:42:30.27 spid80 * R14: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * R15: 0000000000000000:
> 2007-06-06 11:42:30.27 spid80 * Rip: 000000000100A841:
> 74C085662241B70F 41896601E8836608 7F3944663B8B4822 0F247F39440A7522
> 0002BF00009F0A84 247D833E89440000
> 2007-06-06 11:42:30.27 spid80 *
> ****************************************
**********************************
*****
> 2007-06-06 11:42:30.27 spid80 *
> ----
--
> 2007-06-06 11:42:30.27 spid80 * Short Stack Dump
> 2007-06-06 11:42:30.32 spid80 000000000100A841
> Module(sqlservr+000000000000A841)
> 2007-06-06 11:42:30.32 spid80 00000000011BCF36
> Module(sqlservr+00000000001BCF36)
> 2007-06-06 11:42:30.32 spid80 00000000011BCDB2
> Module(sqlservr+00000000001BCDB2)
> 2007-06-06 11:42:30.32 spid80 00000000010B68D3
> Module(sqlservr+00000000000B68D3)
> 2007-06-06 11:42:30.32 spid80 0000000001021C98
> Module(sqlservr+0000000000021C98)
> 2007-06-06 11:42:30.32 spid80 000000000171A50F
> Module(sqlservr+000000000071A50F)
> 2007-06-06 11:42:30.32 spid80 00000000010DED5F
> Module(sqlservr+00000000000DED5F)
> 2007-06-06 11:42:30.32 spid80 00000000010DE75B
> Module(sqlservr+00000000000DE75B)
> 2007-06-06 11:42:30.32 spid80 000000000134C327
> Module(sqlservr+000000000034C327)
> 2007-06-06 11:42:30.32 spid80 000000000134C2DF
> Module(sqlservr+000000000034C2DF)
> 2007-06-06 11:42:30.32 spid80 0000000001354770
> Module(sqlservr+0000000000354770)
> 2007-06-06 11:42:30.32 spid80 000000000134CD93
> Module(sqlservr+000000000034CD93)
> 2007-06-06 11:42:30.32 spid80 000000000134B876
> Module(sqlservr+000000000034B876)
> 2007-06-06 11:42:30.32 spid80 000000000100685E
> Module(sqlservr+000000000000685E)
> 2007-06-06 11:42:30.32 spid80 0000000001006F11
> Module(sqlservr+0000000000006F11)
> 2007-06-06 11:42:30.32 spid80 0000000001006A01
> Module(sqlservr+0000000000006A01)
> 2007-06-06 11:42:30.32 spid80 00000000010EF7A7
> Module(sqlservr+00000000000EF7A7)
> 2007-06-06 11:42:30.32 spid80 00000000010F051A
> Module(sqlservr+00000000000F051A)
> 2007-06-06 11:42:30.32 spid80 00000000010F03F1
> Module(sqlservr+00000000000F03F1)
> 2007-06-06 11:42:30.33 spid80 00000000010F0289
> Module(sqlservr+00000000000F0289)
> 2007-06-06 11:42:30.33 spid80 00000000781337A7
> Module(MSVCR80+00000000000037A7)
> 2007-06-06 11:42:30.33 spid80 0000000078133864
> Module(MSVCR80+0000000000003864)
> 2007-06-06 11:42:30.35 spid80 0000000077D6B69A
> Module(kernel32+000000000002B69A)
> 2007-06-06 11:42:30.36 spid80 Stack Signature for the dump is
> 0x00000001F2D1D3FC
> 2007-06-06 11:42:30.39 Logon Login succeeded for user
> 'PATRIA\Babulakova'. Connection: trusted. [CLIENT: 10.0.1.58]
> 2007-06-06 11:42:34.16 spid80 External dump process return code
> 0x20000001.
> External dump process returned no errors.
>