How Do I Prevent A SQL Error Terminating My Package?

RESTORE FILELIST Is Terminating Abnormally Error When Running A DTS Package In SQL 2005. Works Fine In SQL 2000
Currently I receive the following error when executing script within a DTS package in SQL 2005 (it seems to be working in SQL 2000):
 

Processed 27008 pages for database 'Marketing', file 'Marketing_Data' on file 5.

Processed 1 pages for database 'Marketing', file 'Marketing_Log' on file 5.

BACKUP DATABASE successfully processed 27009 pages in 15.043 seconds (14.708 MB/sec).

(5 row(s) affected)

Msg 213, Level 16, State 7, Line 1

Insert Error: Column name or number of supplied values does not match table definition.

Msg 3013, Level 16, State 1, Line 1

RESTORE FILELIST is terminating abnormally.
 
The code I am using is:
 

-- the original database (use 'SET @DB = NULL' to disable backup)

DECLARE @DB varchar(200)

SET @DB = 'Marketing'

-- the backup filename

DECLARE @BackupFile varchar(2000)

SET @BackupFile = 'C:SQL2005 dbsMarketing.dat'

-- the new database name

DECLARE @TestDB2 varchar(200)

SET @TestDB2 = datename(month, dateadd(month, -1, getdate())) + convert(varchar(20), year(getdate())) + 'Inst1'

-- the new database files without .mdf/.ldf

DECLARE @RestoreFile varchar(2000)

SET @RestoreFile = 'C:SQL2005 dbs' + @TestDB2

DECLARE @RestoreLog varchar (2000)

SET @RestoreLog = 'C:SQL2005 dbs' + @TestDB2

-- ****************************************************************

-- no change below this line

-- ****************************************************************

DECLARE @query varchar(2000)

DECLARE @DataFile varchar(2000)

SET @DataFile = @RestoreFile + '.mdf'

DECLARE @LogFile varchar(2000)

SET @LogFile = @RestoreLog + '.ldf'

IF @DB IS NOT NULL

BEGIN

SET @query = 'BACKUP DATABASE ' + @DB + ' TO DISK = ' + QUOTENAME(@BackupFile, '''')

EXEC (@query)

END

-- RESTORE FILELISTONLY FROM DISK = 'C: empackup.dat'

-- RESTORE HEADERONLY FROM DISK = 'C: empackup.dat'

-- RESTORE LABELONLY FROM DISK = 'C: empackup.dat'

-- RESTORE VERIFYONLY FROM DISK = 'C: empackup.dat'

 

 

 

IF EXISTS(SELECT * FROM sysdatabases WHERE name = @TestDB2)

BEGIN

SET @query = 'DROP DATABASE ' + @TestDB2

EXEC (@query)

END

RESTORE HEADERONLY FROM DISK = @BackupFile

DECLARE @File int

SET @File = @@ROWCOUNT

DECLARE @Data varchar(500)

DECLARE @Log varchar(500)

SET @query = 'RESTORE FILELISTONLY FROM DISK = ' + QUOTENAME(@BackupFile , '''')

CREATE TABLE #restoretemp

(

LogicalName varchar(500),

PhysicalName varchar(500),

type varchar(10),

FilegroupName varchar(200),

size int,

maxsize bigint

)

INSERT #restoretemp EXEC (@query)

SELECT @Data = LogicalName FROM #restoretemp WHERE type = 'D'

SELECT @Log = LogicalName FROM #restoretemp WHERE type = 'L'

PRINT @Data

PRINT @Log

TRUNCATE TABLE #restoretemp

DROP TABLE #restoretemp

IF @File > 0

BEGIN

SET @query = 'RESTORE DATABASE ' + @TestDB2 + ' FROM DISK = ' + QUOTENAME(@BackupFile, '''') +

' WITH MOVE ' + QUOTENAME(@Data, '''') + ' TO ' + QUOTENAME(@DataFile, '''') + ', MOVE ' +

QUOTENAME(@Log, '''') + ' TO ' + QUOTENAME(@LogFile, '''') + ', FILE = ' + CONVERT(varchar, @File)

EXEC (@query)

END


 
 
 
 

View Replies !

---

About Programmatically Disabling The Tasks, Manually Terminating Further Flow In A Package
Hi folks,

    I have come across a situation where there 10 tasks. The second task on the flow is a script task which disables all further tasks based on a condition. I thought that the logic would be better if we force terminate the package  successfully at this stage itself. How can this be done.

 

Thanks

Subhash Subramanyam

View Replies !

---

DTS Package - How To Prevent A 0 Byte File?
I've created a DTS package -- that uses a query to export to a .txt file. My question is -- if the results of this query are zero (no results returned within the package ) -- how can I tell the package not to export a zero byte file. Any thoughts on that? Any help you could give would be greatly appreciated. Thanks!

View Replies !

---

Prevent Simultaneous Package Executions
How can I prevent a package, or a section of a package, from being run more than once simultaneously? The package makes use of a staging database table, and if two copies of this package are run at the same time, there will be a race condition and possible corruption of the data in the database table. I have also noticed that the SSIS logging gets messed up and starts overwriting itself if I have more than one of these packages run at the same time.
 
What I am thinking of should work the same way as a serializable transaction lock on a normal query, where one query has to wait if another query has a lock on the table. I don't want the package to throw an error, I want it to wait until the other one is done.
 
I have been trying to use transactions in a test SSIS package, but they are not quite doing what I want them to do. I put various SSIS steps in a sequence container and require a serializable transaction. I have also tried putting the transaction at the package level, but that is not preventing simultaneous package runs.
 
Is there a built-in way to do this that is easy to implement? Otherwise, what I could do is insert a flag into the database indicating that a package is running, then make sure to reset the flag on any error or on completion. It seems like this alternate method could be error-prone though.
 
I am using SP2.

View Replies !

---

Temp Tables Not Dropped On Batch-terminating Error
 

If a stored procedure creates a temporary table and then has a batch-terminating error -- either a fatal error or a non-fatal error in "xact_abort on" mode -- the temp table does not get dropped even though it goes out of scope:
 

create proc px as

create table #z(z1 int primary key)

insert #z values ('x')

go

exec px

go

select * from tempdb.sys.tables where name like '#z%' --returns row for #z

drop table #z --fails because #z out of scope

 
or:
 

create proc px as

set xact_abort on

create table #z(z1 int primary key)

insert #z values (0)

insert #z values (0)

go

exec px

go

select * from tempdb.sys.tables where name like '#z%' --returns row for #z

drop table #z --fails because #z out of scope
 
Is this behavior by design? It does not appear to be documented properly if so, since BOL states that "Temporary tables are automatically dropped when they go out of scope".
 
In any case, is there a way to delete leftover temp tables from tempdb without restarting SQL Server?
 
Thanks,
Ron
 

View Replies !

---

Log File Is Full Error: How To Prevent This Happening?
"The log file for database is full. Back up the transaction log forthe database to free up some log space."Now I only know this way to deal with that manually,Step1. in option , chance Recovery model from FULL to Simple.Step2: go to task to manually shrink the log fileStep3: Change recovery model back from simple to FULL.But by this way, I could get same problem again, the log file is fill,and need free up.Could you give an idea how to prevent this from happening? what andhow should I do???Thanks a lot in advance for your help.

View Replies !

---

Prevent Error Being Thrown When No Messages Exist
I am using the following code to check whether a message exists on the specified queue:
 



Code Block
DECLARE @RecvReplyMsg NVARCHAR(100);
DECLARE @RecvReplyDlgHandle UNIQUEIDENTIFIER;
BEGIN TRANSACTION;
RECEIVE TOP(1)
@RecvReplyDlgHandle = conversation_handle,
@RecvReplyMsg = message_body
FROM TargetQueue;
END CONVERSATION @RecvReplyDlgHandle;
SELECT @RecvReplyMsg AS ReceivedReplyMsg;
COMMIT TRANSACTION;
GO
 
 
How can I prevent errors being thrown when there are no messages waiting on the queue? For example, if I send a message to the queue and run the above twice I get the following:
 

Msg 8418, Level 16, State 1, Line 11

The conversation handle is missing. Specify a conversation handle.

 
Thanks

View Replies !

---

I Have DTS Package Even I Getting Error &&"Error String: The Specified DTS Package ('Name = 'ERP_Mater_Encript_Data_Move'; ID.Ver
Hi
 
My Server having DTS package even Job failing saying
"Error string:  The specified DTS Package ('Name = 'ERP_Mater_Encript_Data_Move'; ID.VersionID =  {[not specified]}.{T0I37w32-AB51-1SA4-9495-AcE6SSS4a321}') does not exist"
 
 
 
 
Please help regarding.

View Replies !

---

Load A SSIS Package Via Web Service: The Package Failed To Load Due To Error 0xC0011008 &&"Error Loading From XML.WHAT IS THAT?
Hello,

I have a big problem and i'm not able to find any hint on the Network.

I have a window2000 pc, VS2005,II5 and SQLServer 2005(dev edition)

I created an SSIS Package (query to DB and the result is loaded into an Excel file) that works fine.

I imported the dtsx file inside my "Stored Packages".

I would like to load and run the package programmatically on a Remote Scenario using the web services.

I created a solution with  web service and web page that invoke the web service.

When my code execute:
Microsoft.SqlServer.Dts.Runtime.Application.LoadFromDtsServer(packagePath, ".", Nothing)

I got the Error:
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.

The error message doesn't help so much and there is nothing on the www to give me and advice....

Is it a SSIS problem???

Thank you for any help!!

Marina B.

 

 

View Replies !

---

SQL Server Terminating
Has anyone come across SQL server terminating unexpectably and then proceeding to restart itself. There is no alerts set to restart the process, there are no errors in SQL errorlog, in NT Event log there is a error that SQL terminated unexpectably , and then 1 second later a message that it is restarting as normal. Any clues or encounters of this behaivour before and fixes would be appreciated

View Replies !

---

SQL Server Connections Not Terminating
We have an application that runs against SQL Server 6.5 or 7.0. At one location that was recently upgraded from 6.5 to 7.0 we have a problem with the user connections to SQL Server not terminating when the user terminates the application. At some point, after several days, they are forced to bounce the server to eliminate the errant connections becasue SQL Server tells them they have the maximum number of connections. This only happens at one site and it happened under 6.5 as well. At all other sites, the connections terminate when the application terminates. Any ideas????

View Replies !

---

Restoration Terminating Abnormally
Hi,

This is the problem which we face now and then. There is an automated job that run everyday night to restore the Database for reporting purposes. Before running that job an NT Task Schedular stop starts the sql server. This is to make sure that all the connections are closed. Nobody uses it at Night. But some times the job fails with bellow error message...

"Database in use. The system administrator must have exclusive use of the database to run the restore operation. [SQLSTATE 42000] (Error 3101) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013) Associated statement is not prepared [SQLSTATE HY007] (Error 0). The step failed."

Should I make the DB option set to single user mode. I don't think that is the problem.. because it runs fine most of the time..but sometime it fails.
Please help.. Thanks in advance :-)

Shyam.

View Replies !

---

BACKUP LOG Is Terminating Abnormally
Hi! I have a db with Full recovery model, when i try to run Transaction Log Backup, i get this error- sometimes sooner than reaching 90 percent, in spite of friendly working that i had before.

10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
Msg 3202, Level 16, State 2, Line 1
Write on "D:Simaap_BackupSimaapFullBackup_870218" failed: 112(error not found)
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

Any solution would be appreciated!!
Thanks!

 

View Replies !

---

RESTORE DATABASE Is Terminating Abnormally.
Hello,I am getting the rather odd error below; hope you can help.RESTORE DATABASE is terminating abnormally. File 'C:Program FilesMicrosoftSQL ServerMSSQL.1MSSQLData rial_44testingc' is claimed by'sysft_KB_SearchAssetsCatalog'(65540) and 'sysft_KB_SearchCatalog'(65537).The WITH MOVE clause can be used to relocate one or more files.I get this from an app our company uses to programatically restoredatabases. Below are the queries we are using:Create database trial_44testingcselect COUNT(*) as TOTAL from sysdatabases where name = 'trial_44testingc'RESTORE FILELISTONLY FROM disk ='C:HostedTrialManagementAppSourcedb43_trialmas ter'RESTORE DATABASE trial_44testingc FROM disk ='C:HostedTrialManagementAppSourcedb43_trialmas ter' WITH RECOVERY , MOVE'43_trialmaster' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc.mdf', MOVE '43_trialmaster_log'TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc.ldf', MOVE'sysft_KB_SearchCatalog' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc', MOVE'sysft_KB_SearchTicketsCatalog' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc', MOVE'sysft_KB_SearchTicketsCatalog2' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc', MOVE'sysft_KB_SearchAssetsCatalog' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc'This had been working great until I made some updates to the table structureof the db and created a new backup.Any ideas?TIAJake

View Replies !

---

RESTORE FILELIST Is Terminating Abnormally
'm a noob, using MS SQL 2005. Trying to use a stored procedure I got from SQL 2000 DB integrity to work with 2005. Receiving:


Message
Executed as user: MMCRSDOM eletracksql. Insert Error: Column name or number of supplied values does not match table definition. [SQLSTATE 21S01] (Error 213) RESTORE FILELIST is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

Please help.

View Replies !

---

Backup Log Is Terminating Abnormally Because Memory.
Hello, everyone:

I have a job to backup transcation log files hourly. It is has been ruuning well. This morning it was failed. I did transcation log file backup by hand, and got this message,

SQL-DMO(ODBC SQLState: 4200)
There is insufficient system memory to run this query. Backup Log is terminating abnormally.

Any suggestion will appreciated.

Thanks

ZYT

View Replies !

---

EXCEPTION_ACCESS_VIOLATION. SQL Server Is Terminating This Process.
Hi, Folks!

I need some light about this trouble, I have Sql server 7, sp2

the server is raising this error:
[Microsoft SQL-DMO (ODBC SQLState: HY000)] Error 1918: [Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler: Process 15 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

when I'm reindexing a clustered index. If that index is not clustered it works fine!

Any idea???

Armando Marrero
Cti. Miami

View Replies !

---

BACKUP DATABASE Is Terminating Abnormally
I am receiving an error

"Database 'MyDatabase' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details. BACKUP DATABASE is terminating abnormally."

each time I click on the button code below.




Code Snippet
Private Sub BACK_UP_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BACK_UP.Click
   

cmd = New SqlCommand("BACKUP DATABASE" & Me.cbdatabase.Text & "TO DISK = 'Documents and SettingsMy DocumentsPERSONAL DOCUMENTSfilename.bak' ", conn);
        conn.Open()
        cmd.ExecuteNonQuery()
        conn.Close()

End Sub

The VB application is running from an Open SQL Server 2005 user account - ie No user account has been created for it. Do anyone know how I can resolve this issue from VB 2005 Express.

View Replies !

---

SQL Server Is Terminating Due To 'stop' Request Fr
Hiya

Since yesterday the sqlserver service has been falling over, my error logs says the below?

006-04-26 11:28:41.64 spid51 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'sp_MSgetversion'.
2006-04-26 11:28:41.92 spid51 Error: 15457, Severity: 0, State: 1
2006-04-26 11:28:41.92 spid51 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2006-04-26 11:28:42.04 spid51 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
2006-04-26 14:44:08.92 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.

What do I need to do? Is is just a matter of running the reconfigure script? Yesterday night we had some monitoring installed on the server. Can anyone help?

Thanks

View Replies !

---

Error Creating Package - Failed To Save Package File &&"... Emp EmpD4B.tmp&&" With Error 0x80040154 &&"Class Not Registered&&"
I had just installed SQL 2005 dev on my laptop and got an error message when I tried to create a package using the BI IDE. I received the same error using VS2005 IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again, but with an option to view the error details.
 
Following is the text of the error details:
 
TITLE: Microsoft Visual Studio
------------------------------
 
Error creating package
 
------------------------------
ADDITIONAL INFORMATION:
 
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
 

------------------------------
 
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
 

------------------------------
BUTTONS:
 
OK
------------------------------
I found a similar post that suggested that they try the following:
 

regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll
 
But msxml6.dll could not be found.
 
I did get a copy of this file from a coworker, and after copying it and registering it, I was able to add a package to the project.
 
My concern now is what is the likelyhood of this being the only file missing from the installation.
 
I'm wondering if I should reinstall, or (if it exists) do a repair on the installation.
 
Thanks.
 
Marshall

View Replies !

---

ODBC Connection Not Terminating After Client Diconnects
Hi,

We have SQLSERVER 7.0 in one of the production.
The clients r connected thru ODBC.
The clients doesn't gets disconnected after a task result in
increase in sqlserver log.

Can anyone advice me .

Thanks in advance
Anu

View Replies !

---

SQL Server Is Terminating Because Of Fatal Exception C0000005.
Hello

My Server is restarting every time a OLAP process a cube dimension...

The query's are generated by the OLAP engine and are selecting from views that are depended on AS400 linked server.

I' m posting the log and dump

SQL Server Log

/*--------------------------------------------------------------*/

Date,Source,Severity,Message
06/30/2007 19:20:51,spid7s,Unknown,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
06/30/2007 19:20:51,spid70,Unknown,SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception<c/> or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error<c/> restart the server (unless SQLAgent is configured to auto restart).
06/30/2007 19:20:51,spid70,Unknown,Error: 17311<c/> Severity: 16<c/> State: 1.
06/30/2007 19:20:51,spid70,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
06/30/2007 19:20:49,spid70,Unknown,Stack Signature for the dump is 0x943A0CDA
06/30/2007 19:20:49,spid70,Unknown,78132A36 Module(MSVCR80+00002A36)
06/30/2007 19:20:49,spid70,Unknown,781329AA Module(MSVCR80+000029AA)
06/30/2007 19:20:49,spid70,Unknown,0146753D Module(sqlservr+0046753D)
06/30/2007 19:20:49,spid70,Unknown,01466761 Module(sqlservr+00466761)
06/30/2007 19:20:49,spid70,Unknown,014676D8 Module(sqlservr+004676D8)
06/30/2007 19:20:49,spid70,Unknown,014677E1 Module(sqlservr+004677E1)
06/30/2007 19:20:49,spid70,Unknown,01006F3B Module(sqlservr+00006F3B)
06/30/2007 19:20:49,spid70,Unknown,01006D4C Module(sqlservr+00006D4C)
06/30/2007 19:20:49,spid70,Unknown,01006C26 Module(sqlservr+00006C26)
06/30/2007 19:20:49,spid70,Unknown,0104A331 Module(sqlservr+0004A331)
06/30/2007 19:20:49,spid70,Unknown,0104AB65 Module(sqlservr+0004AB65)
06/30/2007 19:20:49,spid70,Unknown,01028C01 Module(sqlservr+00028C01)
06/30/2007 19:20:49,spid70,Unknown,01029D74 Module(sqlservr+00029D74)
06/30/2007 19:20:49,spid70,Unknown,010297DA Module(sqlservr+000297DA)
06/30/2007 19:20:49,spid70,Unknown,0103D211 Module(sqlservr+0003D211)
06/30/2007 19:20:49,spid70,Unknown,0103CEF9 Module(sqlservr+0003CEF9)
06/30/2007 19:20:49,spid70,Unknown,0103CFBA Module(sqlservr+0003CFBA)
06/30/2007 19:20:49,spid70,Unknown,0109DD66 Module(sqlservr+0009DD66)
06/30/2007 19:20:49,spid70,Unknown,0109FB6C Module(sqlservr+0009FB6C)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E7DE Module(sqlservr+0034E7DE)
06/30/2007 19:20:49,spid70,Unknown,0138B3AB Module(sqlservr+0038B3AB)
06/30/2007 19:20:49,spid70,Unknown,010420A3 Module(sqlservr+000420A3)
06/30/2007 19:20:49,spid70,Unknown,01042083 Module(sqlservr+00042083)
06/30/2007 19:20:49,spid70,Unknown,01041E15 Module(sqlservr+00041E15)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E8EC Module(sqlservr+0034E8EC)
06/30/2007 19:20:49,spid70,Unknown,0134E600 Module(sqlservr+0034E600)
06/30/2007 19:20:49,spid70,Unknown,0104019A Module(sqlservr+0004019A)
06/30/2007 19:20:49,spid70,Unknown,0104E95A Module(sqlservr+0004E95A)
06/30/2007 19:20:49,spid70,Unknown,014E7287 Module(sqlservr+004E7287)
06/30/2007 19:20:49,spid70,Unknown,01E53EEB Module(sqlservr+00E53EEB)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E7DE Module(sqlservr+0034E7DE)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134EE0E Module(sqlservr+0034EE0E)
06/30/2007 19:20:49,spid70,Unknown,013513CB Module(sqlservr+003513CB)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E7DE Module(sqlservr+0034E7DE)
06/30/2007 19:20:49,spid70,Unknown,0138B3AB Module(sqlservr+0038B3AB)
06/30/2007 19:20:49,spid70,Unknown,010420A3 Module(sqlservr+000420A3)
06/30/2007 19:20:49,spid70,Unknown,01042083 Module(sqlservr+00042083)
06/30/2007 19:20:49,spid70,Unknown,01041E15 Module(sqlservr+00041E15)
06/30/2007 19:20:49,spid70,Unknown,01E4E7C6 Module(sqlservr+00E4E7C6)
06/30/2007 19:20:49,spid70,Unknown,01E4F63E Module(sqlservr+00E4F63E)
06/30/2007 19:20:49,spid70,Unknown,0171A1E6 Module(sqlservr+0071A1E6)
06/30/2007 19:20:49,spid70,Unknown,01718FE0 Module(sqlservr+00718FE0)
06/30/2007 19:20:49,spid70,Unknown,017033EB Module(sqlservr+007033EB)
06/30/2007 19:20:49,spid70,Unknown,017031E2 Module(sqlservr+007031E2)
06/30/2007 19:20:49,spid70,Unknown,88000000 Module(UNKNOWN+00000000)
06/30/2007 19:20:49,spid70,Unknown,* Short Stack Dump
06/30/2007 19:20:49,spid70,Unknown,* -------------------------------------------------------------------------------
06/30/2007 19:20:49,spid70,Unknown,* *******************************************************************************
06/30/2007 19:20:49,spid70,Unknown,*      SegSs: 00000023:
06/30/2007 19:20:49,spid70,Unknown,*        Esp: 075FEE1C:  017031E2  65006900  015C37F8  075FEE3C  075F8169  00000000
06/30/2007 19:20:49,spid70,Unknown,*     EFlags: 00010246:  004E005F  00000054  00610050  00680074  0043003D  005C003A
06/30/2007 19:20:49,spid70,Unknown,*      SegCs: 0000001B:
06/30/2007 19:20:49,spid70,Unknown,*        Ebp: 075FEEA4:  075FEFB8  017033EB  015C37F8  65006900  0109CFA4  00000001
06/30/2007 19:20:49,spid70,Unknown,*        Eip: 88000000:  00040101  00010000  00001D15  00550001  00001D30  00190001
06/30/2007 19:20:49,spid70,Unknown,*        Edx: 015C37F8:  0C733A1D  11CE2A1C  AA00E5AD  3D774400  0C733A5D  11CE2A1C
06/30/2007 19:20:49,spid70,Unknown,*        Ecx: 075FEE3C:  00000000  00936188  00000000  5E2200E8  00000000  00000000
06/30/2007 19:20:49,spid70,Unknown,*        Ebx: 65006900:  00140001  0000A80D  00671B36  000AEC00  00000300  00140001
06/30/2007 19:20:49,spid70,Unknown,*        Eax: 88000000:  00040101  00010000  00001D15  00550001  00001D30  00190001
06/30/2007 19:20:49,spid70,Unknown,*        Esi: 6F179D58:  6F179DC8  2DA5069E  11D656C4  20005B92  3997AE35  00000000
06/30/2007 19:20:49,spid70,Unknown,*        Edi: 00000000:
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* dbghelp                        09660000  09774FFF  00115000
06/30/2007 19:20:49,spid70,Unknown,* sqlvdi                         072B0000  072D1FFF  00022000
06/30/2007 19:20:49,spid70,Unknown,* SXS                            75DA0000  75E5BFFF  000bc000
06/30/2007 19:20:49,spid70,Unknown,* adsldp                         08DE0000  08E0DFFF  0002e000
06/30/2007 19:20:49,spid70,Unknown,* ATL                            76A80000  76A97FFF  00018000
06/30/2007 19:20:49,spid70,Unknown,* credui                         76B80000  76BADFFF  0002e000
06/30/2007 19:20:49,spid70,Unknown,* adsldpc                        76DC0000  76DE6FFF  00027000
06/30/2007 19:20:49,spid70,Unknown,* activeds                       76DF0000  76E22FFF  00033000
06/30/2007 19:20:49,spid70,Unknown,* cwbcomsg                       08DD0000  08DDEFFF  0000f000
06/30/2007 19:20:49,spid70,Unknown,* comsvcs                        75B70000  75CA8FFF  00139000
06/30/2007 19:20:49,spid70,Unknown,* CWBZMODB                       08CC0000  08CC3FFF  00004000
06/30/2007 19:20:49,spid70,Unknown,* CWBSOMRI                       08CA0000  08CADFFF  0000e000
06/30/2007 19:20:49,spid70,Unknown,* cwbdt                          08AF0000  08AF7FFF  00008000
06/30/2007 19:20:49,spid70,Unknown,* cwbdq                          08AD0000  08AEDFFF  0001e000
06/30/2007 19:20:49,spid70,Unknown,* cwbbspc                        08AB0000  08AC3FFF  00014000
06/30/2007 19:20:49,spid70,Unknown,* cwbbsspi                       08AA0000  08AAFFFF  00010000
06/30/2007 19:20:49,spid70,Unknown,* cwbnl                          08A90000  08A94FFF  00005000
06/30/2007 19:20:49,spid70,Unknown,* cwbad                          08A80000  08A83FFF  00004000
06/30/2007 19:20:49,spid70,Unknown,* cwbco                          08A70000  08A74FFF  00005000
06/30/2007 19:20:49,spid70,Unknown,* cwbsv                          08A60000  08A65FFF  00006000
06/30/2007 19:20:49,spid70,Unknown,* cwbunssl                       08A40000  08A51FFF  00012000
06/30/2007 19:20:49,spid70,Unknown,* cwbrc                          08A30000  08A3EFFF  0000f000
06/30/2007 19:20:49,spid70,Unknown,* cwbsof                         08A00000  08A2EFFF  0002f000
06/30/2007 19:20:49,spid70,Unknown,* CWBUNPLA                       089B0000  089F2FFF  00043000
06/30/2007 19:20:49,spid70,Unknown,* cwbad1                         089A0000  089A7FFF  00008000
06/30/2007 19:20:49,spid70,Unknown,* SHFOLDER                       766D0000  766D8FFF  00009000
06/30/2007 19:20:49,spid70,Unknown,* MSVCIRT                        08990000  0899FFFF  00010000
06/30/2007 19:20:49,spid70,Unknown,* cwbrw                          08960000  08989FFF  0002a000
06/30/2007 19:20:49,spid70,Unknown,* iertutil                       08910000  08954FFF  00045000
06/30/2007 19:20:49,spid70,Unknown,* Normaliz                       08900000  08908FFF  00009000
06/30/2007 19:20:49,spid70,Unknown,* WININET                        08830000  088FEFFF  000cf000
06/30/2007 19:20:49,spid70,Unknown,* MFC42u                         08700000  08823FFF  00124000
06/30/2007 19:20:49,spid70,Unknown,* cwbunpls                       068E0000  068EBFFF  0000c000
06/30/2007 19:20:49,spid70,Unknown,* cwbcore                        08610000  086F6FFF  000e7000
06/30/2007 19:20:49,spid70,Unknown,* cwbdc                          085E0000  08606FFF  00027000
06/30/2007 19:20:49,spid70,Unknown,* cwbzzodb                       084E0000  085DDFFF  000fe000
06/30/2007 19:20:49,spid70,Unknown,* OLEDB32R                       068C0000  068D0FFF  00011000
06/30/2007 19:20:49,spid70,Unknown,* MSDART                         74A50000  74A69FFF  0001a000
06/30/2007 19:20:49,spid70,Unknown,* oledb32                        070B0000  07128FFF  00079000
06/30/2007 19:20:49,spid70,Unknown,* xplog70                        08070000  08072FFF  00003000
06/30/2007 19:20:49,spid70,Unknown,* xplog70                        08050000  0805BFFF  0000c000
06/30/2007 19:20:49,spid70,Unknown,* xpstar90                       08020000  08045FFF  00026000
06/30/2007 19:20:49,spid70,Unknown,* odbcint                        08000000  08016FFF  00017000
06/30/2007 19:20:49,spid70,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
06/30/2007 19:20:49,spid70,Unknown,* BatchParser90                  07E90000  07EAEFFF  0001f000
06/30/2007 19:20:49,spid70,Unknown,* ODBC32                         07E50000  07E8CFFF  0003d000
06/30/2007 19:20:49,spid70,Unknown,* SQLSCM90                       07E30000  07E38FFF  00009000
06/30/2007 19:20:49,spid70,Unknown,* xpstar90                       07DD0000  07E18FFF  00049000
06/30/2007 19:20:49,spid70,Unknown,* xpsqlbot                       07DB0000  07DB5FFF  00006000
06/30/2007 19:20:49,spid70,Unknown,* msftepxy                       07130000  07144FFF  00015000
06/30/2007 19:20:49,spid70,Unknown,* SQLNCLIR                       007A0000  007D2FFF  00033000
06/30/2007 19:20:49,spid70,Unknown,* comdlg32                       762B0000  762F9FFF  0004a000
06/30/2007 19:20:49,spid70,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
06/30/2007 19:20:49,spid70,Unknown,* sqlncli                        337A0000  339C3FFF  00224000
06/30/2007 19:20:49,spid70,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
06/30/2007 19:20:49,spid70,Unknown,* xpsp2res                       10000000  102C4FFF  002c5000
06/30/2007 19:20:49,spid70,Unknown,* ntdsapi                        766F0000  76704FFF  00015000
06/30/2007 19:20:49,spid70,Unknown,* SAMLIB                         06F70000  06F7EFFF  0000f000
06/30/2007 19:20:49,spid70,Unknown,* NTMARTA                        77E00000  77E21FFF  00022000
06/30/2007 19:20:49,spid70,Unknown,* dssenh                         06F80000  06FA3FFF  00024000
06/30/2007 19:20:49,spid70,Unknown,* imagehlp                       76C10000  76C38FFF  00029000
06/30/2007 19:20:49,spid70,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
06/30/2007 19:20:49,spid70,Unknown,* dbghelp                        06C10000  06D24FFF  00115000
06/30/2007 19:20:49,spid70,Unknown,* msfte                          069B0000  06C08FFF  00259000
06/30/2007 19:20:49,spid70,Unknown,* security                       06190000  06193FFF  00004000
06/30/2007 19:20:49,spid70,Unknown,* wshtcpip                       05CC0000  05CC7FFF  00008000
06/30/2007 19:20:49,spid70,Unknown,* hnetcfg                        05C20000  05C78FFF  00059000
06/30/2007 19:20:49,spid70,Unknown,* rasadhlp                       76F80000  76F87FFF  00008000
06/30/2007 19:20:49,spid70,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
06/30/2007 19:20:49,spid70,Unknown,* winrnr                         76F70000  76F76FFF  00007000
06/30/2007 19:20:49,spid70,Unknown,* DNSAPI                         76ED0000  76EFEFFF  0002f000
06/30/2007 19:20:49,spid70,Unknown,* WSOCK32                        71BB0000  71BB8FFF  00009000
06/30/2007 19:20:49,spid70,Unknown,* VERSION                        77B90000  77B97FFF  00008000
06/30/2007 19:20:49,spid70,Unknown,* MTXCLU                         74F40000  74F58FFF  00019000
06/30/2007 19:20:49,spid70,Unknown,* msvcp60                        780C0000  78120FFF  00061000
06/30/2007 19:20:49,spid70,Unknown,* MSDTCPRX                       05B30000  05BA7FFF  00078000
06/30/2007 19:20:49,spid70,Unknown,* XOLEHLP                        05B20000  05B25FFF  00006000
06/30/2007 19:20:49,spid70,Unknown,* COMRES                         77010000  770D5FFF  000c6000
06/30/2007 19:20:49,spid70,Unknown,* schannel                       76750000  76776FFF  00027000
06/30/2007 19:20:49,spid70,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
06/30/2007 19:20:49,spid70,Unknown,* kerberos                       05A70000  05AC7FFF  00058000
06/30/2007 19:20:49,spid70,Unknown,* iphlpapi                       76CF0000  76D09FFF  0001a000
06/30/2007 19:20:49,spid70,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
06/30/2007 19:20:49,spid70,Unknown,* MSCOREE                        05800000  05844FFF  00045000
06/30/2007 19:20:49,spid70,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
06/30/2007 19:20:49,spid70,Unknown,* rsaenh                         04D20000  04D4EFFF  0002f000
06/30/2007 19:20:49,spid70,Unknown,* SQLOS                          344D0000  344D4FFF  00005000
06/30/2007 19:20:49,spid70,Unknown,* sqlevn70                       4F610000  4F7B8FFF  001a9000
06/30/2007 19:20:49,spid70,Unknown,* RESUTILS                       74EF0000  74F02FFF  00013000
06/30/2007 19:20:49,spid70,Unknown,* OLEAUT32                       77D00000  77D8BFFF  0008c000
06/30/2007 19:20:49,spid70,Unknown,* ole32                          77670000  777A3FFF  00134000
06/30/2007 19:20:49,spid70,Unknown,* CLUSAPI                        74DE0000  74DF1FFF  00012000
06/30/2007 19:20:49,spid70,Unknown,* instapi                        48060000  48069FFF  0000a000
06/30/2007 19:20:49,spid70,Unknown,* psapi                          76B70000  76B7AFFF  0000b000
06/30/2007 19:20:49,spid70,Unknown,* comctl32                       77420000  77522FFF  00103000
06/30/2007 19:20:49,spid70,Unknown,* IMM32                          76290000  762ACFFF  0001d000
06/30/2007 19:20:49,spid70,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
06/30/2007 19:20:49,spid70,Unknown,* SHELL32                        7C8D0000  7D0D3FFF  00804000
06/30/2007 19:20:49,spid70,Unknown,* NETAPI32                       71C40000  71C97FFF  00058000
06/30/2007 19:20:49,spid70,Unknown,* opends60                       333E0000  333E6FFF  00007000
06/30/2007 19:20:49,spid70,Unknown,* USERENV                        76920000  769E3FFF  000c4000
06/30/2007 19:20:49,spid70,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
06/30/2007 19:20:49,spid70,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
06/30/2007 19:20:49,spid70,Unknown,* MSWSOCK                        71B20000  71B60FFF  00041000
06/30/2007 19:20:49,spid70,Unknown,* Secur32                        76F50000  76F62FFF  00013000
06/30/2007 19:20:49,spid70,Unknown,* MSASN1                         76190000  761A1FFF  00012000
06/30/2007 19:20:49,spid70,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
06/30/2007 19:20:49,spid70,Unknown,* GDI32                          77C00000  77C48FFF  00049000
06/30/2007 19:20:49,spid70,Unknown,* USER32                         77380000  77411FFF  00092000
06/30/2007 19:20:49,spid70,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
06/30/2007 19:20:49,spid70,Unknown,* ADVAPI32                       77F50000  77FEBFFF  0009c000
06/30/2007 19:20:49,spid70,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
06/30/2007 19:20:49,spid70,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
06/30/2007 19:20:49,spid70,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
06/30/2007 19:20:49,spid70,Unknown,* kernel32                       77E40000  77F41FFF  00102000
06/30/2007 19:20:49,spid70,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
06/30/2007 19:20:49,spid70,Unknown,* sqlservr                       01000000  02C0AFFF  01c0b000
06/30/2007 19:20:49,spid70,Unknown,*  MODULE                          BASE      END       SIZE
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,*  _ccost].[dbo_dim_ccostCOST_ID2_1]   )     )
06/30/2007 19:20:49,spid70,Unknown,*  OST_ID]   )      AND     (    [dimUserNameCCost].[COST_ID]   =  [dbo_dim
06/30/2007 19:20:49,spid70,Unknown,*   (    [dbo_dim_ccost].[dbo_dim_ccostCOST_ID2_1]   =  [dbo_dim_ccost1].[C
06/30/2007 19:20:49,spid70,Unknown,*  dimDIV_CCOST_USERNAME]      )      AS [dbo_dim_ccost]   WHERE    (
06/30/2007 19:20:49,spid70,Unknown,*  o_dim_ccostdiv2_0]<c/>[COST_ID] AS [dbo_dim_ccostCOST_ID2_1]   FROM [dbo].[
06/30/2007 19:20:49,spid70,Unknown,*  t] AS [dbo_dim_ccost1]<c/>      (          SELECT    DISTINCT  [div] AS [db
06/30/2007 19:20:49,spid70,Unknown,*  M         dimUserNameCCost    )    AS [dimUserNameCCost]<c/>[dbo].[dim_ccos
06/30/2007 19:20:49,spid70,Unknown,*     SAMACCOUNTNAME + 'MEGATV' AS USR<c/> USERNAME<c/> COST_ID<c/> displayname FRO
06/30/2007 19:20:49,spid70,Unknown,*  .[dbo_dim_ccostdiv2_0] AS [dbo_dim_ccostdiv2_0]   FROM     (    SELECT
06/30/2007 19:20:49,spid70,Unknown,*  im_ccost1].[COST_DESCR] AS [dbo_dim_ccost1COST_DESCR1_0]<c/>[dbo_dim_ccost]
06/30/2007 19:20:49,spid70,Unknown,*  0_2]<c/>[dimUserNameCCost].[COST_ID] AS [dimUserNameCCostCOST_ID0_3]<c/>[dbo_d
06/30/2007 19:20:49,spid70,Unknown,*  AME0_1]<c/>[dimUserNameCCost].[displayname] AS [dimUserNameCCostdisplayname
06/30/2007 19:20:49,spid70,Unknown,*  NameCCostUSR0_0]<c/>[dimUserNameCCost].[USERNAME] AS [dimUserNameCCostUSERN
06/30/2007 19:20:49,spid70,Unknown,*                  SELECT    DISTINCT  [dimUserNameCCost].[USR] AS [dimUser
06/30/2007 19:20:49,spid70,Unknown,* Input Buffer 510 bytes -
06/30/2007 19:20:49,spid70,Unknown,*   Access Violation occurred writing address 88000000
06/30/2007 19:20:49,spid70,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
06/30/2007 19:20:49,spid70,Unknown,*   Exception Address = 88000000 Module(UNKNOWN+00000000)
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,*   06/30/07 19:20:49 spid 70
06/30/2007 19:20:49,spid70,Unknown,* BEGIN STACK DUMP:
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* *******************************************************************************
06/30/2007 19:20:49,spid70,Unknown,SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
06/30/2007 19:20:49,spid70,Unknown,***Stack Dump being sent to S:MSSQLMSSQL.1MSSQLLOGSQLDump0008.txt
06/30/2007 19:20:49,spid70,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/30/2007 04:07:01,Backup,Unknown,Database backed up. Database: tvmar<c/> creation date(time): 2007/04/18(20:36:58)<c/> pages dumped: 1126<c/> first LSN: 185:4607:48<c/> last LSN: 185:4627:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#625feb9b-cc56-49ad-8b8f-24471cc2d889'}). This is an informational message only. No user action is required.
06/30/2007 04:06:59,Backup,Unknown,Database backed up. Database: msdb<c/> creation date(time): 2005/10/14(01:54:05)<c/> pages dumped: 1579<c/> first LSN: 741:216:261<c/> last LSN: 741:328:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#af5c48e2-5b0b-4042-868d-6b28f7f5d657'}). This is an informational message only. No user action is required.
06/30/2007 04:06:55,Backup,Unknown,Database backed up. Database: model<c/> creation date(time): 2003/04/08(09:13:36)<c/> pages dumped: 189<c/> first LSN: 37:416:37<c/> last LSN: 37:440:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c79803b2-6fad-4187-b658-66d71ceb315e'}). This is an informational message only. No user action is required.
06/30/2007 04:06:53,Backup,Unknown,Database backed up. Database: master<c/> creation date(time): 2007/06/28(13:34:15)<c/> pages dumped: 387<c/> first LSN: 1076:400:37<c/> last LSN: 1076:424:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c4a63fb1-ad81-44c0-8625-a2e18e1ac6ec'}). This is an informational message only. No user action is required.
06/30/2007 04:06:50,Backup,Unknown,Database backed up. Database: intranet<c/> creation date(time): 2007/03/21(14:33:52)<c/> pages dumped: 219<c/> first LSN: 27:659:37<c/> last LSN: 27:675:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#46625684-d128-4a77-8d48-bd55a043773a'}). This is an informational message only. No user action is required.
06/30/2007 04:06:48,Backup,Unknown,Database backed up. Database: facilityTest<c/> creation date(time): 2007/03/30(19:23:59)<c/> pages dumped: 7600<c/> first LSN: 242:20105:207<c/> last LSN: 242:20187:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#717e4863-92f3-4060-9a96-cfbdaf7574ca'}). This is an informational message only. No user action is required.
06/30/2007 04:06:44,Backup,Unknown,Database backed up. Database: as400<c/> creation date(time): 2007/03/29(16:40:01)<c/> pages dumped: 187<c/> first LSN: 31:81:37<c/> last LSN: 31:97:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#94c2f4db-37ad-42a0-842a-4ee151868f39'}). This is an informational message only. No user action is required.
06/30/2007 04:06:41,Backup,Unknown,Database backed up. Database: RCREW_EURO<c/> creation date(time): 2007/03/20(15:04:19)<c/> pages dumped: 787<c/> first LSN: 26:4189:37<c/> last LSN: 26:4205:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#45e46e0c-dc9e-4895-8fd6-b96ac9717094'}). This is an informational message only. No user action is required.
06/30/2007 04:06:38,Backup,Unknown,Database backed up. Database: RCREW<c/> creation date(time): 2007/03/20(14:54:00)<c/> pages dumped: 683<c/> first LSN: 27:3697:37<c/> last LSN: 27:3713:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#353bb158-7e11-45c4-8eef-c04721a42df8'}). This is an informational message only. No user action is required.
06/30/2007 04:06:36,Backup,Unknown,Database backed up. Database: ORIGINTICKER<c/> creation date(time): 2007/03/21(17:50:58)<c/> pages dumped: 1015885<c/> first LSN: 3543267:95:104<c/> last LSN: 3543267:1129:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2b249260-808e-4abf-9a46-6117c58788b6'}). This is an informational message only. No user action is required.
06/30/2007 04:04:17,Backup,Unknown,Database backed up. Database: OCCUPATION<c/> creation date(time): 2007/03/30(19:19:29)<c/> pages dumped: 10315<c/> first LSN: 29:66521:69<c/> last LSN: 29:66549:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#ff36832c-71d7-4e58-b3b6-1c2e44afcae4'}). This is an informational message only. No user action is required.
06/30/2007 04:04:13,Backup,Unknown,Database backed up. Database: NEWSLINE<c/> creation date(time): 2007/03/23(15:14:29)<c/> pages dumped: 539<c/> first LSN: 27:2842:37<c/> last LSN: 27:2858:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#953b7822-79c0-4e47-8806-2cdc01633de0'}). This is an informational message only. No user action is required.
06/30/2007 04:04:10,Backup,Unknown,Database backed up. Database: NEWSFILE<c/> creation date(time): 2007/03/23(11:49:44)<c/> pages dumped: 223872<c/> first LSN: 5679:18451:91<c/> last LSN: 5679:18498:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#e90a643f-0ab4-43af-82ed-50b85835ac65'}). This is an informational message only. No user action is required.
06/30/2007 04:03:28,Backup,Unknown,Database backed up. Database: MegaLIB<c/> creation date(time): 2007/05/17(16:20:40)<c/> pages dumped: 187<c/> first LSN: 34:1747:37<c/> last LSN: 34:1763:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c3d1693b-cc9c-4556-a5bf-f98a3e303755'}). This is an informational message only. No user action is required.
06/30/2007 04:03:25,Backup,Unknown,Database backed up. Database: INVENTORY<c/> creation date(time): 2007/03/23(12:17:43)<c/> pages dumped: 11966<c/> first LSN: 412:1404:95<c/> last LSN: 412:1443:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#901722b7-e555-46f1-8e11-f84994ef133e'}). This is an informational message only. No user action is required.
06/30/2007 04:03:19,Backup,Unknown,Database backed up. Database: INEWS<c/> creation date(time): 2007/03/23(14:23:54)<c/> pages dumped: 15643<c/> first LSN: 95:24345:79<c/> last LSN: 95:24378:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2e399870-8002-4b6c-bdad-906245fcc331'}). This is an informational message only. No user action is required.
06/30/2007 04:03:15,Backup,Unknown,Database backed up. Database: HyperionSS<c/> creation date(time): 2007/03/19(17:55:10)<c/> pages dumped: 349<c/> first LSN: 124:2015:74<c/> last LSN: 124:2045:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#5138e34c-9a19-4ff7-92e2-42a0e1af7a6a'}). This is an informational message only. No user action is required.
06/30/2007 04:03:12,Backup,Unknown,Database backed up. Database: HyperionBI<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 1099<c/> first LSN: 48:1336:37<c/> last LSN: 48:1352:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#ceeecf9e-6d4b-4ec4-b541-635cfa1a7012'}). This is an informational message only. No user action is required.
06/30/2007 04:03:09,Backup,Unknown,Database backed up. Database: HyperionAIS<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 195<c/> first LSN: 44:704:37<c/> last LSN: 44:720:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#798e76c1-c6bb-45a1-ac7c-73a7c386b090'}). This is an informational message only. No user action is required.
06/30/2007 04:03:07,Backup,Unknown,Database backed up. Database: HyperionAAS<c/> creation date(time): 2007/03/19(17:53:48)<c/> pages dumped: 491<c/> first LSN: 45:2848:37<c/> last LSN: 45:2864:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#f7d829ef-a850-43ba-a576-d7293254ccf4'}). This is an informational message only. No user action is required.
06/30/2007 04:03:04,Backup,Unknown,Database backed up. Database: HOTLINE<c/> creation date(time): 2007/03/20(10:54:42)<c/> pages dumped: 267<c/> first LSN: 25:4137:37<c/> last LSN: 25:4153:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#92a1de2a-936d-4048-8c5e-05b6ab2434d2'}). This is an informational message only. No user action is required.
06/30/2007 04:03:02,Backup,Unknown,Database backed up. Database: EMEDIA<c/> creation date(time): 2007/03/26(12:27:39)<c/> pages dumped: 235<c/> first LSN: 59:1198:58<c/> last LSN: 59:1222:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#7e28ff07-08e6-4eed-bf80-38ba1e4627ea'}). This is an informational message only. No user action is required.
06/30/2007 04:02:59,Backup,Unknown,Database backed up. Database: EKLOGES_OLD<c/> creation date(time): 2007/03/19(15:17:03)<c/> pages dumped: 291<c/> first LSN: 26:439:37<c/> last LSN: 26:455:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#dc8d9b3e-7928-42b9-9e61-32ae03d68a56'}). This is an informational message only. No user action is required.
06/30/2007 04:02:56,Backup,Unknown,Database backed up. Database: EKLOGES_2006w1<c/> creation date(time): 2007/03/19(15:13:58)<c/> pages dumped: 2475<c/> first LSN: 26:19205:37<c/> last LSN: 26:19221:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#67613979-2561-4519-a919-ce7ee21d01e5'}). This is an informational message only. No user action is required.
06/30/2007 04:02:49,Backup,Unknown,Database backed up. Database: EKLOGES_2004v<c/> creation date(time): 2007/03/19(14:59:27)<c/> pages dumped: 3143<c/> first LSN: 60:982:37<c/> last LSN: 60:998:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a19662a8-4397-4ee3-bd06-d58f2e010203'}). This is an informational message only. No user action is required.
06/30/2007 04:02:46,Backup,Unknown,Database backed up. Database: EKLOGES_2002w2<c/> creation date(time): 2007/03/19(14:52:44)<c/> pages dumped: 3555<c/> first LSN: 26:13056:37<c/> last LSN: 26:13072:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#8f1f1d10-b189-43fc-aed8-0c92ece14d41'}). This is an informational message only. No user action is required.
06/30/2007 04:02:43,Backup,Unknown,Database backed up. Database: EKLOGES_2002w1<c/> creation date(time): 2007/03/19(14:50:21)<c/> pages dumped: 2579<c/> first LSN: 25:16928:37<c/> last LSN: 25:16944:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c2c3f2e9-1ccf-4721-982b-4d17f38457a9'}). This is an informational message only. No user action is required.
06/30/2007 04:02:40,Backup,Unknown,Database backed up. Database: EKLOGES<c/> creation date(time): 2007/03/19(14:45:35)<c/> pages dumped: 6667<c/> first LSN: 40:2427:37<c/> last LSN: 40:2443:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#9cc652ff-96da-48bf-bc4c-ebc5ca53d010'}). This is an informational message only. No user action is required.
06/30/2007 04:02:35,Backup,Unknown,Database backed up. Database: EDUCATION<c/> creation date(time): 2007/03/19(15:24:25)<c/> pages dumped: 515<c/> first LSN: 25:9018:37<c/> last LSN: 25:9034:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#dbe7459f-c466-456f-ad68-4cef5d73f21f'}). This is an informational message only. No user action is required.
06/30/2007 04:02:33,Backup,Unknown,Database backed up. Database: CitrixDS<c/> creation date(time): 2007/03/26(17:43:57)<c/> pages dumped: 539<c/> first LSN: 27:7897:37<c/> last LSN: 27:7913:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#3b027d4d-4e2f-4c0e-b555-b7a4f8a25c66'}). This is an informational message only. No user action is required.
06/30/2007 04:02:29,Backup,Unknown,Database backed up. Database: CSDB7<c/> creation date(time): 2007/04/19(13:27:08)<c/> pages dumped: 2865<c/> first LSN: 198:413:37<c/> last LSN: 198:429:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#247141fd-14a3-4fdf-9de0-97688403c6fa'}). This is an informational message only. No user action is required.
06/30/2007 04:02:26,Backup,Unknown,Database backed up. Database: CSDB<c/> creation date(time): 2007/03/26(16:18:53)<c/> pages dumped: 2354<c/> first LSN: 158:464:37<c/> last LSN: 158:480:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#449a6f8a-be30-4c65-a590-8fd67a5b000f'}). This is an informational message only. No user action is required.
06/30/2007 04:02:23,Backup,Unknown,Database backed up. Database: ANALYZ72<c/> creation date(time): 2007/03/20(11:51:27)<c/> pages dumped: 307<c/> first LSN: 25:4012:37<c/> last LSN: 25:4028:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1d9869b3-cce4-4c71-8747-19e955367fec'}). This is an informational message only. No user action is required.
06/30/2007 04:02:20,Backup,Unknown,Database backed up. Database: AEPI<c/> creation date(time): 2007/03/21(16:08:39)<c/> pages dumped: 7843<c/> first LSN: 29:15235:81<c/> last LSN: 29:15268:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#4dbe1fa4-0089-48a0-8b46-54ff5679d3e5'}). This is an informational message only. No user action is required.
06/30/2007 00:00:04,spid17s,Unknown,This instance of SQL Server has been using a process ID of 4788 since 28/6/2007 1:34:28 μμ (local) 28/6/2007 10:34:28 πμ (UTC). This is an informational message only; no user action is required.
06/29/2007 23:22:15,Logon,Unknown,Login failed for user 'MEGATVsuper1'. [CLIENT: 10.1.0.90]
06/29/2007 23:22:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
06/29/2007 15:42:34,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:34,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:32,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:32,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:30,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:20,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:20,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:16,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:16,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:13,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:13,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:11,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:11,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:09,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:06,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:06,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:02,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:02,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:01,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:01,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:00,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:41:58,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:41:58,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:41:50,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:41:50,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:41:10,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:41:10,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:58,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:58,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:40,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:40,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:21,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:21,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:15,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:12,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:12,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:39:56,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:39:56,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:39:24,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:39:24,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:38:56,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:38:56,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:38:35,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:38:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:38:30,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:38:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:37:59,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:37:59,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:37:54,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:37:54,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:35,Logon,Unknown,Login failed for user 'gavogiac'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/29/2007 15:36:30,Logon,Unknown,Login failed for user 'gavogiac'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/29/2007 15:36:30,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:20,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:20,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:19,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:19,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:17,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:17,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:15,Logon,Unknown,Login failed for user 'gavogiac'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/29/2007 15:36:09,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:05,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:05,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:00,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:54,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:54,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:49,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:49,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:44,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:38,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:38,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:29,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:29,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:25,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:25,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:34:36,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:34:36,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:34:31,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:34:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:34:31,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:34:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:33:55,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:33:55,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:33:43,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:33:43,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:32:56,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:32:56,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:30:23,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:30:23,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:30:02,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:30:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:28:08,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:28:08,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:27:55,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:27:55,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 04:07:52,Backup,Unknown,Database backed up. Database: tvmar<c/> creation date(time): 2007/04/18(20:36:58)<c/> pages dumped: 1126<c/> first LSN: 185:4003:48<c/> last LSN: 185:4023:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#5687baaa-002a-4f65-8bb7-2f2ba5d735df'}). This is an informational message only. No user action is required.
06/29/2007 04:07:49,Backup,Unknown,Database backed up. Database: msdb<c/> creation date(time): 2005/10/14(01:54:05)<c/> pages dumped: 1579<c/> first LSN: 732:176:173<c/> last LSN: 732:256:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#e05a8e22-2f32-492e-8412-145e9b9b9b09'}). This is an informational message only. No user action is required.
06/29/2007 04:07:45,Backup,Unknown,Database backed up. Database: model<c/> creation date(time): 2003/04/08(09:13:36)<c/> pages dumped: 189<c/> first LSN: 37:352:37<c/> last LSN: 37:376:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1d2c5054-e7c1-4bdf-9799-b22b2c050f9d'}). This is an informational message only. No user action is required.
06/29/2007 04:07:43,Backup,Unknown,Database backed up. Database: master<c/> creation date(time): 2007/06/28(13:34:15)<c/> pages dumped: 387<c/> first LSN: 1063:488:37<c/> last LSN: 1064:16:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b18252f8-58b9-4997-9c24-f18f49a92f19'}). This is an informational message only. No user action is required.
06/29/2007 04:07:40,Backup,Unknown,Database backed up. Database: intranet<c/> creation date(time): 2007/03/21(14:33:52)<c/> pages dumped: 219<c/> first LSN: 27:635:37<c/> last LSN: 27:651:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#f16b3299-bedc-4c50-b223-b49a59247f72'}). This is an informational message only. No user action is required.
06/29/2007 04:07:37,Backup,Unknown,Database backed up. Database: facilityTest<c/> creation date(time): 2007/03/30(19:23:59)<c/> pages dumped: 7592<c/> first LSN: 242:16437:260<c/> last LSN: 242:16540:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#40b0b72f-e411-47ab-be0e-873148db25ad'}). This is an informational message only. No user action is required.
06/29/2007 04:07:32,Backup,Unknown,Database backed up. Database: as400<c/> creation date(time): 2007/03/29(16:40:01)<c/> pages dumped: 187<c/> first LSN: 31:57:37<c/> last LSN: 31:73:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#666a5305-593a-4079-8b5f-1d3b32198312'}). This is an informational message only. No user action is required.
06/29/2007 04:07:29,Backup,Unknown,Database backed up. Database: RCREW_EURO<c/> creation date(time): 2007/03/20(15:04:19)<c/> pages dumped: 787<c/> first LSN: 26:4165:37<c/> last LSN: 26:4181:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2666bdfc-27c7-4131-a923-cfafd2843977'}). This is an informational message only. No user action is required.
06/29/2007 04:07:27,Backup,Unknown,Database backed up. Database: RCREW<c/> creation date(time): 2007/03/20(14:54:00)<c/> pages dumped: 683<c/> first LSN: 27:3673:37<c/> last LSN: 27:3689:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#9230e56f-cf09-47b1-9655-f854eda23636'}). This is an informational message only. No user action is required.
06/29/2007 04:07:24,Backup,Unknown,Database backed up. Database: ORIGINTICKER<c/> creation date(time): 2007/03/21(17:50:58)<c/> pages dumped: 1013805<c/> first LSN: 3537241:231:143<c/> last LSN: 3537249:1119:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#306bb758-9bc1-48fd-88bc-68b38e83e30b'}). This is an informational message only. No user action is required.
06/29/2007 04:05:07,Backup,Unknown,Database backed up. Database: OCCUPATION<c/> creation date(time): 2007/03/30(19:19:29)<c/> pages dumped: 10315<c/> first LSN: 29:66381:78<c/> last LSN: 29:66413:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a10445fe-fb7c-4721-891a-2a588c17f8e1'}). This is an informational message only. No user action is required.
06/29/2007 04:05:02,Backup,Unknown,Database backed up. Database: NEWSLINE<c/> creation date(time): 2007/03/23(15:14:29)<c/> pages dumped: 539<c/> first LSN: 27:2818:37<c/> last LSN: 27:2834:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#43f574a6-d674-4779-b661-4ceb3659e29b'}). This is an informational message only. No user action is required.
06/29/2007 04:04:59,Backup,Unknown,Database backed up. Database: NEWSFILE<c/> creation date(time): 2007/03/23(11:49:44)<c/> pages dumped: 223800<c/> first LSN: 5678:38062:91<c/> last LSN: 5678:38108:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#e0b6624f-f9e9-4f3e-960c-abf307b31e49'}). This is an informational message only. No user action is required.
06/29/2007 04:04:11,Backup,Unknown,Database backed up. Database: MegaLIB<c/> creation date(time): 2007/05/17(16:20:40)<c/> pages dumped: 187<c/> first LSN: 34:1723:37<c/> last LSN: 34:1739:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2a63636e-9639-492e-bf69-e42085d19a47'}). This is an informational message only. No user action is required.
06/29/2007 04:04:09,Backup,Unknown,Database backed up. Database: INVENTORY<c/> creation date(time): 2007/03/23(12:17:43)<c/> pages dumped: 11798<c/> first LSN: 411:2409:65<c/> last LSN: 411:2435:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#706d845f-e3d7-4a7b-8521-629f89be2a73'}). This is an informational message only. No user action is required.
06/29/2007 04:04:04,Backup,Unknown,Database backed up. Database: INEWS<c/> creation date(time): 2007/03/23(14:23:54)<c/> pages dumped: 15627<c/> first LSN: 94:16404:72<c/> last LSN: 94:16434:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#eb05358a-f960-4c53-9eb2-6fb542b640a4'}). This is an informational message only. No user action is required.
06/29/2007 04:03:58,Backup,Unknown,Database backed up. Database: HyperionSS<c/> creation date(time): 2007/03/19(17:55:10)<c/> pages dumped: 349<c/> first LSN: 124:1380:74<c/> last LSN: 124:1410:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#3c61f90d-c761-400b-9918-3cd100842ad4'}). This is an informational message only. No user action is required.
06/29/2007 04:03:55,Backup,Unknown,Database backed up. Database: HyperionBI<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 1099<c/> first LSN: 48:1312:37<c/> last LSN: 48:1328:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#d48daf21-497e-4397-924b-3811a7260cc8'}). This is an informational message only. No user action is required.
06/29/2007 04:03:52,Backup,Unknown,Database backed up. Database: HyperionAIS<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 195<c/> first LSN: 44:680:37<c/> last LSN: 44:696:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b2194d80-1c8d-4d6c-aad5-161e090814d3'}). This is an informational message only. No user action is required.
06/29/2007 04:03:49,Backup,Unknown,Database backed up. Database: HyperionAAS<c/> creation date(time): 2007/03/19(17:53:48)<c/> pages dumped: 491<c/> first LSN: 45:2824:37<c/> last LSN: 45:2840:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b25941f5-f32e-43fb-a6c5-74d121fb3f90'}). This is an informational message only. No user action is required.
06/29/2007 04:03:47,Backup,Unknown,Database backed up. Database: HOTLINE<c/> creation date(time): 2007/03/20(10:54:42)<c/> pages dumped: 267<c/> first LSN: 25:4113:37<c/> last LSN: 25:4129:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#18c5054e-490b-473b-9e0b-5bab4593272e'}). This is an informational message only. No user action is required.
06/29/2007 04:03:44,Backup,Unknown,Database backed up. Database: EMEDIA<c/> creation date(time): 2007/03/26(12:27:39)<c/> pages dumped: 235<c/> first LSN: 58:3684:58<c/> last LSN: 58:3708:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1c62a71b-f0e6-43a5-a96c-ecd342022daf'}). This is an informational message only. No user action is required.
06/29/2007 04:03:41,Backup,Unknown,Database backed up. Database: EKLOGES_OLD<c/> creation date(time): 2007/03/19(15:17:03)<c/> pages dumped: 291<c/> first LSN: 26:416:37<c/> last LSN: 26:432:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a9b40e52-6465-4744-a401-406901789e0c'}). This is an informational message only. No user action is required.
06/29/2007 04:03:37,Backup,Unknown,Database backed up. Database: EKLOGES_2006w1<c/> creation date(time): 2007/03/19(15:13:58)<c/> pages dumped: 2475<c/> first LSN: 26:19181:37<c/> last LSN: 26:19197:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#da624ff6-6c35-4c97-9665-e6fa6c5c5765'}). This is an informational message only. No user action is required.
06/29/2007 04:03:34,Backup,Unknown,Database backed up. Database: EKLOGES_2004v<c/> creation date(time): 2007/03/19(14:59:27)<c/> pages dumped: 3143<c/> first LSN: 60:958:37<c/> last LSN: 60:974:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a52b3691-b199-4efe-ab95-792d79013466'}). This is an informational message only. No user action is required.
06/29/2007 04:03:30,Backup,Unknown,Database backed up. Database: EKLOGES_2002w2<c/> creation date(time): 2007/03/19(14:52:44)<c/> pages dumped: 3555<c/> first LSN: 26:13032:37<c/> last LSN: 26:13048:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1132c8d3-a0cb-49f8-aee0-9169489d9535'}). This is an informational message only. No user action is required.
06/29/2007 04:02:59,Backup,Unknown,Database backed up. Database: EKLOGES_2002w1<c/> creation date(time): 2007/03/19(14:50:21)<c/> pages dumped: 2579<c/> first LSN: 25:16904:37<c/> last LSN: 25:16920:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2c22053b-4415-4206-9b1e-16a19ca00293'}). This is an informational message only. No user action is required.
06/29/2007 04:02:54,Backup,Unknown,Database backed up. Database: EKLOGES<c/> creation date(time): 2007/03/19(14:45:35)<c/> pages dumped: 6667<c/> first LSN: 40:2403:37<c/> last LSN: 40:2419:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#977ee3c9-f843-42ab-830e-4c42da263a9f'}). This is an informational message only. No user action is required.
06/29/2007 04:02:50,Backup,Unknown,Database backed up. Database: EDUCATION<c/> creation date(time): 2007/03/19(15:24:25)<c/> pages dumped: 515<c/> first LSN: 25:8994:37<c/> last LSN: 25:9010:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1d554fee-ea6f-4fdc-9106-072cc02dbd1c'}). This is an informational message only. No user action is required.
06/29/2007 04:02:47,Backup,Unknown,Database backed up. Database: CitrixDS<c/> creation date(time): 2007/03/26(17:43:57)<c/> pages dumped: 539<c/> first LSN: 27:7873:37<c/> last LSN: 27:7889:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b7613cbf-8d0b-46e4-96ee-ae4641da731f'}). This is an informational message only. No user action is required.
06/29/2007 04:02:44,Backup,Unknown,Database backed up. Database: CSDB7<c/> creation date(time): 2007/04/19(13:27:08)<c/> pages dumped: 2865<c/> first LSN: 198:389:37<c/> last LSN: 198:405:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#9ab05cf5-7b40-46cc-a0ad-8beeb5ae3b9d'}). This is an informational message only. No user action is required.
06/29/2007 04:02:39,Backup,Unknown,Database backed up. Database: CSDB<c/> creation date(time): 2007/03/26(16:18:53)<c/> pages dumped: 2354<c/> first LSN: 158:440:37<c/> last LSN: 158:456:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#d37e1310-fb07-403e-a70d-1c0931a2257d'}). This is an informational message only. No user action is required.
06/29/2007 04:02:35,Backup,Unknown,Database backed up. Database: ANALYZ72<c/> creation date(time): 2007/03/20(11:51:27)<c/> pages dumped: 307<c/> first LSN: 25:3988:37<c/> last LSN: 25:4004:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#02b53ae8-417e-48f0-a73c-a22ea9e7a604'}). This is an informational message only. No user action is required.
06/29/2007 04:02:31,Backup,Unknown,Database backed up. Database: AEPI<c/> creation date(time): 2007/03/21(16:08:39)<c/> pages dumped: 7835<c/> first LSN: 29:13524:37<c/> last LSN: 29:13540:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c7479e38-213b-4a41-a7bf-6c82b12f25d1'}). This is an informational message only. No user action is required.
06/29/2007 00:00:19,spid18s,Unknown,This instance of SQL Server has been using a process ID of 4788 since 28/6/2007 1:34:28 μμ (local) 28/6/2007 10:34:28 πμ (UTC). This is an informational message only; no user action is required.
06/28/2007 19:54:57,Logon,Unknown,Login failed for user 'MEGATVpaternag'. [CLIENT: 10.1.1.43]
06/28/2007 19:54:57,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
06/28/2007 19:53:23,Logon,Unknown,Login failed for user 'MEGATVpaternag'. [CLIENT: 10.1.1.43]
06/28/2007 19:53:23,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
06/28/2007 19:53:05,Logon,Unknown,Login failed for user 'pilot'. [CLIENT: 10.1.1.43]
06/28/2007 19:53:05,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/28/2007 19:51:30,Logon,Unknown,Login failed for user 'pilot'. [CLIENT: 10.1.1.43]
06/28/2007 19:51:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/28/2007 19:50:47,Logon,Unknown,Login failed for user 'pilotusr'. [CLIENT: 10.1.1.43]
06/28/2007 19:50:47,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/28/2007 16:48:01,Server,Unknown,A user request from the session with SPID 75 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
06/28/2007 16:48:01,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
06/28/2007 16:48:01,spid75,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
06/28/2007 16:48:01,spid75,Unknown,Stack Signature for the dump is 0x975B0CDA
06/28/2007 16:48:01,spid75,Unknown,78132A36 Module(MSVCR80+00002A36)
06/28/2007 16:48:01,spid75,Unknown,781329AA Module(MSVCR80+000029AA)
06/28/2007 16:48:01,spid75,Unknown,0146753D Module(sqlservr+0046753D)
06/28/2007 16:48:01,spid75,Unknown,01466761 Module(sqlservr+00466761)
06/28/2007 16:48:01,spid75,Unknown,014676D8 Module(sqlservr+004676D8)
06/28/2007 16:48:01,spid75,Unknown,014677E1 Module(sqlservr+004677E1)
06/28/2007 16:48:01,spid75,Unknown,01006F3B Module(sqlservr+00006F3B)
06/28/2007 16:48:01,spid75,Unknown,01006D4C Module(sqlservr+00006D4C)
06/28/2007 16:48:01,spid75,Unknown,01006C26 Module(sqlservr+00006C26)
06/28/2007 16:48:01,spid75,Unknown,0104A331 Module(sqlservr+0004A331)
06/28/2007 16:48:01,spid75,Unknown,0104AB65 Module(sqlservr+0004AB65)
06/28/2007 16:48:01,spid75,Unk

View Replies !

---

HELP: SQL Server Is Terminating Because Of Fatal Exception C0000005
 

Hi,
 
We're using SQL Server 2005 SP2, and got an error message of:
 
SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
 
Does anyone know what is the cause of this error and how to fix it.
 
Thanks in advance, Maxim

View Replies !

---

Flat File Destination - Output Not Terminating
Im reading from one flat file and outputting to another. the input flat file is not fixed width and columns are seperated with commas. I want the output in fixed width format but for some reason my output lines are not terminating where they should be. what should I check on my flat file destination mgr ?

View Replies !

---

Package Validation Error : The Package Designer Deletes The Code From Script Task.
While Creating a script task in Control Flow, I am getting "Package Validation Error". Here is the complete message:

Error at Validate File and  Load Data: The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated.
 (Microsoft.DataTransformationServices.VsIntegration)

As mentioned in the message, I opened the script IDE and added the code I need. When I close the VSA IDE, package designer displays the same error message.

The worst part of whole story is that if I close the package designer and reopen it, I find that all the code I wrote in the script task has been deleted by the package designer. This is not at all acceptable as I saved the package the and still lost all my work. I did all the coding from scratch for that task.

Please respond if anyone faced similar problem.

Thanks in advance!

Anand

PS: If any one from Microsoft is reading this, please see what you guys are coding there. Due to the buggy software you deliver, I am loosing my credibility.<P< P>

View Replies !

---

Error Stating Package Failure While Executing SSIS Package In Standard Edition
Hi,

      I have developed an SSIS package for ETL purpose. I am invoking the SSIS package through .Net console application by referencing the ManagedDTS Assembly. I am able to execute the package in Sql Server 2005  Developer Edition and it runs fine till completion.

But when i try to execute the packahe in Sql Server 2005 Standard edition, by invoking the package  through .Net console application the status of the package is failure.

 Can any one help me how to over come this problem.

 

 

View Replies !

---

Fix To BUG: You Receive An Error Message When You Use The Package Migration Wizard To Migrate A DTS Package
 


 






Article ID
:
917420
CAUSE
This problem occurs when one of the following conditions is true:



€¢
The name of the DTS package starts with a space.

€¢
The name of the DTS package ends with a space.

€¢
The name of the DTS package contains a character that is invalid in SQL Server 2005 Integration Services (SSIS).

My Workaroud was execute the follow script in MSDB in SQL 2000

Update sysdtspackages

set name = rtrim(ltrim(name))


This script fix all DTS Package with names with spaces at start and ends.

Jose G. Yovera

MCSE MCDBA

Consein C.A.

Venezuela

 

View Replies !

---

BUG: You Receive An Error Message When You Use The Package Migration Wizard To Migrate A DTS Package
 


 






Article ID
:
917420
CAUSE
This problem occurs when one of the following conditions is true:



€¢
The name of the DTS package starts with a space.

€¢
The name of the DTS package ends with a space.

€¢
The name of the DTS package contains a character that is invalid in SQL Server 2005 Integration Services (SSIS).

My Workaroud was execute the follow script in MSDB in SQL 2000

Update sysdtspackages

set name = rtrim(ltrim(name))


This script fix all DTS Package with names with spaces at start and ends.

Regards

Jose G. Yovera

MCSE MCDBA

Consein C.A.

Venezuela

 

View Replies !

---

Apostrophes In Input String Terminating Update Statement
Hi.

I have an update statement that accepts
a user's text input. problem is that the string
terminates the sql update statement if there is
an apostrophe in it. so, headline='i like my brother's car"
willl terminate after "brother". "s car" is read as sql.

how is this resolved?



Code:


Dim MyCmd2 As New Data.SqlClient.SqlCommand("SET ANSI_WARNINGS OFF " & _
"UPDATE EditProfile " & _
"SET headline='"+ Me.tb_headline.Value+"', about_me='"+ Me.ta_aboutme.Value+"', edit_date='"+System.DateTime.Now.ToString+"' WHERE email_address='"+Context.User.Identity.Name.ToString+"' " & _
"SET ANSI_WARNINGS ON ", MyConn)

View Replies !

---

Execute Package Task: Error 0x80070005 While Preparing To Load The Package. Access Is Denied.
I am having problems executing a child package from a parent package using the Execute Package Task. I am attempting to run the master package through a SQL Server Agent job.

The SQL Server Agent job is owned by sa. The step that runs the parent package is configured to load the package from the SSIS Package Store on the same server that the job is running.

I have the Execute Package Task configured as follows:

Location: SQL Server
ExecuteOutOfProcess: True
Connecting as a SQL Server login (let's say TestEtl)

I have added the db_dtsoperator database role to both the TestEtl login and the login that SQL Server Agent connects through. I have also configured the child package's reader role to include db_dtsoperator. Per http://msdn2.microsoft.com/en-US/library/ms141053.aspx, this should allow these logins to run the child package.

I have enabled logging of all events in both the parent and child packages. I see the following in the logs when the Execute Package Task executes (omitted portions unrelated to the execution of the child package task):

450939 OnPreExecute ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450940 OnPreValidate ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450941 OnPostValidate ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450942 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_pre: The object is ready to make the following external request: 'IDataInitialize::GetDataSource'.450943 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_post: 'IDataInitialize::GetDataSource succeeded'. The external request has completed.450944 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_pre: The object is ready to make the following external request: 'IDBInitialize::Initialize'.450945 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_post: 'IDBInitialize::Initialize succeeded'. The external request has completed.450946 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_pre: The object is ready to make the following external request: 'IDBCreateSession::CreateSession'.450947 User: Diagnostic ETL 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 ExternalRequest_post: 'IDBCreateSession::CreateSession succeeded'. The external request has completed.450948 OnError ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 Error 0x80070005 while preparing to load the package. Access is denied. . 450949 OnError ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 Error 0x80070005 while preparing to load the package. Access is denied. . 450950 OnTaskFailed ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450951 OnPostExecute ChildPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450952 OnWarning ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. 450953 OnPostExecute ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 450954 PackageEnd ParentPackage 2007-06-08 13:35:17.000 2007-06-08 13:35:17.000 End of package execution.

I am sure that what I am doing is quite common, and I obviously have something misconfigured somewhere - but I'm not sure what my misconfiguration is. Can anyone enlighten me?

View Replies !

---

SQL Server Is Terminating Due To &#39;stop&#39; Request From Service Control Manager
Hi

I have been getting this message in the event viwer and my SQL server goes down. I have to go and start the service once again. Can somebody throw some light as how to solve this problem?

Please respond.

Tks.

Zolla

View Replies !

---

Exec Pkg Task: Error 0xC0202009 While Preparing To Load The Package. An OLE DB Error Has Occurred. Error Code: 0x%1!8.8X!.
I cannot execute a package by using Execute Package task.
I supplied sa credentials to connection manager, and it shows the list of Packages on SQL Server but when running the task it says

Error 0xC0202009 while preparing to load the package. An OLE DB error has occurred. Error code: 0x%1!8.8X!.



Any clue ?


Thanks,
Fahad

View Replies !

---

Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error Accessing Windows Event Log
 

Hi,
 
I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.
 
Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package  Error Description : Error accessing Windows Event Log."
 
Please help me
 
thanks in advance
 
Srinivas
 
 
 
 

View Replies !

---

Spid3 SQL Server Is Terminating Due To 'stop' Request From Service Control Manager
Installing MSDE (SP3) on a clean updated Win-XP system with all the latest fixes installed unsuccesfully. A clean systems means a fresh installed Win-XP, updated all using webupdate. And Excel 2003 installed. Thats all (not even AntiVirus (yet))

View Replies !

---

RA_Setup_IO [Bucket: 0] [slot: 0]: Process 4 Generated Access Violation; SQL Server Is Terminating T
dear friends/collegs:
for the past couple of weeks, we've been seeing:

SQL Server Error:
"kernel RA_Setup_IO [Bucket: 0] [slot: 0]: Process 4 generated access violation; SQL Server is terminating this process"

we're running SQL Server 6.5 sp4. on NT 4. sp3

View Replies !

---

DTS Package Error Using Execute Package Task
I created a single DTS package with 12 DTS packages in it by using execute package task. Every night the DTS runs and loads the data from mas90 soa files into the sql tables. It's been running fine for 2 weeks and since last few days I was getting the error "Execution was canceled by user" and also attached the detailed error below.
Then did the following tests manually:
Test1. Opened the single DTS packgae which has 12 packages in it and then tried to execute one of the dts package and after a while got the error "Execution was canceled by user"
Test2: Opened one of the 12 individual packages and tried to execute, it ran fine, no problem.
So this is making me to think that because of having 12 dts in a single dts package where I used execute package task, that's what is causing this error. If so, what options I have in order to run 12 dts packages at the same time, any help is greatly appreciated as this is happening in our production database.   
 
Here is the error from the error log:
The execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Execution was canceled by user.
Error code: 80040427
Error Help File : sqldts80.hlp
Error Help Context ID:10100

Package Name: DTSPackage
Package Description: DTS package description
Package ID: {645722E4-C653-48AE-9EB4-9188DD20A599}
Package Version: {2DEEC696-E63F-45B1-8F72-F577E8D23437}
Package Execution Lineage: {BD8FEDC9-3C30-454E-A68A-AC2B99E999CA}
Executed On: servername
Executed By: username
Execution Started: 12/18/2007 11:10:10 AM
Execution Completed: 12/18/2007 11:10:11 AM
Total Execution Time: 0.812 seconds

Package Steps execution information:


Step 'Create Table tablename Step' succeeded
Step Execution Started: 12/18/2007 11:10:10 AM
Step Execution Completed: 12/18/2007 11:10:10 AM
Total Step Execution Time: 0.078 seconds
Progress count in Step: 0

Step 'Copy Data from file to tablename Step' succeeded
Step Execution Started: 12/18/2007 11:10:10 AM
Step Execution Completed: 12/18/2007 11:10:11 AM
Total Step Execution Time: 0.172 seconds
Progress count in Step: 84

Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step Execution Started: 12/18/2007 11:10:10 AM
Step Execution Completed: 12/18/2007 11:10:10 AM
Total Step Execution Time: 0.125 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_2' was not executed

Step 'DTSStep_DTSExecuteSQLTask_3' was not executed

Step 'DTSStep_SDN.SMTPTask_1' was not executed

Step 'DTSStep_SDN.SMTPTask_2' succeeded
Step Execution Started: 12/18/2007 11:10:10 AM
Step Execution Completed: 12/18/2007 11:10:10 AM
Total Step Execution Time: 0.187 seconds
Progress count in Step: 0
Task Log for this step:
-----Start Task Log-----

Error = 1 (00000001), Description = DTS: Log initialized
Error = 1 (00000001), Description = DTS: Log closed

-----End Task Log-----


Step 'DTSStep_SDN.SMTPTask_3' was not executed

Step 'DTSStep_SDN.SMTPTask_4' succeeded
Step Execution Started: 12/18/2007 11:10:10 AM
Step Execution Completed: 12/18/2007 11:10:10 AM
Total Step Execution Time: 0.219 seconds
Progress count in Step: 0
Task Log for this step:
-----Start Task Log-----

Error = 1 (00000001), Description = DTS: Log initialized
Error = 1 (00000001), Description = DTS: Log closed

-----End Task Log-----
 

View Replies !

---

SqlDumpExceptionHandler: Process 3920 Generated Fatal Exception C0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server Is Terminating T
 

Hi Guys,
 
How are you. i hope you all are having fun.
well i have an issue on one of the production box.
Version of the box:  Microsoft SQL Server  2000 - 8.00.2187 (Intel X86)   Mar  9 2006 11:38:51   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

As per SQL serve logs which i received couple of times.
step 1) Using 'dbghelp.dll' version '4.0.5'
          *Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0173.txt
       2) SqlDumpExceptionHandler: Process 3920 generated fatal exception c0000005    
           EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
       3) Stack Signature for the dump is 0xC578316D
 

when i searched in google and msdn i could not found the exact solution.
if you guys have the knowledge and also got experianced about this issue.
kindly please help me in this regards and one more thing i just want to inform you all this is our production server.
I think you would understantd how criticality is this.
 
I really appreciate for your feedback. thank you so much,
 
Raghu

 
for the 2nd step it is haing a very huge message.
so here i have pasted some part of the message. i think this is more then enough for you all.
 
SqlDumpExceptionHandler: Process 3920 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
*   01/17/08 15:30:57 spid 97
*
*   Exception Address = 0041656B
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
*   Access Violation occurred writing address 00380008
* Input Buffer 124 bytes -
*  EXEC MIS..law_ac_totals "G&A", 2008, 3, 100, 204, "emferrario"
* 
*
*  MODULE                          BASE      END       SIZE
* sqlservr                       00400000  00CBEFFF  008bf000
* Invalid Address                77F80000  77FFBFFF  0007c000
* ADVAPI32                       7C2D0000  7C334FFF  00065000
* KERNEL32                       7C570000  7C623FFF  000b4000
* Invalid Address                77D30000  77D9EFFF  0006f000
* MSVCP71                        7C3A0000  7C41AFFF  0007b000
* MSVCR71                        7C340000  7C395FFF  00056000
* opends60                       41060000  41065FFF  00006000
* SHELL32                        7CF30000  7D175FFF  00246000
* GDI32                          77F40000  77F7BFFF  0003c000
* USER32                         77E10000  77E6EFFF  0005f000
* SHLWAPI                        70A70000  70AD5FFF  00066000
* msvcrt                         78000000  78044FFF  00045000
* COMCTL32                       71710000  71793FFF  00084000
* sqlsort                        42AE0000  42B6FFFF
 

View Replies !

---

OLEDB Destination Error In SSIS Package Not Returning Error Column/desc
I have a SSIS package that reads data from a dump table, runs a custom script that takes date data and converts it to the correct format or nulls and formats amt fields to currency, then inserts it to a new table.  The new table redirects insert errors.  This process worked fine until about 3 weeks ago.  I am processing just under 6 million rows, with 460,000 or so insert errors that did give error column and code.

Now, I am getting 1.5 million errors. and nothing has changed, to my knowledge.  I receive the following information.

Error Code   -1071607685   Error Column   0   Error Desc   No status is available. 

The only thing I can find for the above error code is

DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE

To add to the confusion, I can not see any errors in the data written to the error table.  It appears that after a certain point is reached in the processing, everything, or most records, error out.

Any help is appreciated.

Thanks

Derrick

View Replies !

---

Error Running Child Packages From Parent Package - Error 0xC0011008
 

Hey...
 
I am running a parent SSIS package (running sp2, 9.0.3042) that calls several child packages.
 
On our development server, we now cannot run this because we get 1 or more of these errors:
 
"Error 0x80004003 while preparing to load the package. Invalid pointer  .  "
"Error 0xC0011008 while preparing to load the package. Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.  .  "
 
It is not occuring on the same packages.  It varies every time it is run.
 
I can run every one of the child packages individually, using the same login ID that the parent is executed under.
 
The parent package works fine on my local machine and other servers running the same version of SSIS.  Just not on this server.
 
Does anyone have any ideas???
 
Thanks
 
BobP

View Replies !

---

Otain Error Details From A DTS Package Through T-SQL. Was(xp_sendmail On Script Error
SQL Server 2000

Good day all,

I've been asked to create a DTS package that will execute 2 other DTS packages (yeah, I know... personally I want to write a sp for it *shrug*) and send an e-mail out reporting a failure and failure details.

So I have a couple of questions for you;
How do I pick up the error number (and description?) from a failed DTS and pass it to my sendmail task?
Is it possible to send anything other than plain text e-mails?
Can I change the e-mail priority to "high"?

I appreciate any help you can offer me :)

View Replies !

---

SQL Injection - How To Prevent It?
I am building my first ASP.Net app from scratch and while working on the DAL I came across the problem of SQL Injection. I searched on the web and read different articles but I am still unsure about the answer. My question is should I add
 
db.AddInParameter(dbCommand, "AvatarImageID", DbType.Int32, avatarImageID);
 
Add in Parameters to my C# code to avoid SQL Injection. What is the best practice. I am unclear if the stored procedure already helps me avoid SQl Injection or if I need the add in parameters in the C# methods to make it work. I need some help. Thanks, Newbie
 
My C# update method in the DAL (still working on the code)
 
private static bool Update(AvatarImageInfo avatarImage)
        {
            //Invoke a SQL command and return true if the update was successful.
            db.ExecuteNonQuery("syl_AvatarImageUpdate",
                avatarImage.AvatarImageID,
                avatarImage.DateAdded,
                avatarImage.ImageName,
                avatarImage.ImagePath,
                avatarImage.IsApproved);
 
            return true;
        }
 
 
I am using stored procedures to access the data in the database.
 
My update stored proc
 
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
 
ALTER PROCEDURE [dbo].[syl_AvatarImageUpdate]
      @AvatarImageID          int, 
      @DateAdded              datetime,  
      @ImageName              nvarchar(64),    
      @ImagePath              nvarchar(64),    
      @IsApproved             bit
AS
BEGIN
      -- SET NOCOUNT ON added to prevent extra result sets from
      -- interfering with SELECT statements.
      SET NOCOUNT ON;
      BEGIN TRY
            UPDATE      [syl_AvatarImages]
            SET
                        [DateAdded]       = @DateAdded,
                        [ImageName]       = @ImageName,
                        [ImagePath]       = @ImagePath,
                        [IsApproved]      = @IsApproved
            WHERE [AvatarImageID] = @AvatarImageID
            RETURN
      END TRY
      BEGIN CATCH
            --Execute LogError SP  
            EXECUTE [dbo].[syl_LogError];
            --Being in a Catch Block indicates failure.
            --Force RETURN to -1 for consistency (other return values are generated, such as -6).
            RETURN -1
      END CATCH
END

View Replies !

---

Prevent SP Compilation
Hi,I'm using SQL Server 2000 MSDE on a laptop running Windows XP.I have a couple of SP's that that quite some time to compile. So I waswondering: is there any way to have the database *not* recompile them everytime after a reboot?BOL says: "As a database is changed by such actions as adding indexes orchanging data in indexed columns, the original query plans used to accessits tables should be optimized again by recompiling them. This optimizationhappens automatically the first time a stored procedure is run afterMicrosoft® SQL ServerT 2000 is restarted."Now the SQL Server is restarted a lot, because laptops don't have endlessbatteries <g>Cheers,Bas

View Replies !

---

Prevent Sql Job Failure.
Have a job that calls a DTS package, DTS is an Export & Import wizard to copy tables. Someone deleted a table from source and my job failed last night. Inputs appreaciated.

View Replies !

---

How To Prevent Db Deletion
Hi

I want to try and protect myself from my own stupidity. I have a number of sql databases, but one is LIVE. It is easy to drop tables but I want to set something (e.g. a password) which will help prevent me from dropping tables on the live database.

Any help/direction here would be appreciated.

View Replies !

---

Best Way To Prevent Deadlocks
I'm going thru my application log, and just seeing what errors are popping up. I have a relatively intense search feature, thats causing alot of deadlocks.

Exception type: SqlException
Exception message: Transaction (Process ID 105) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

In general, what's the best way to resolve this ?

Should I see if I can apply "WITH (NOLOCK)" to my data ?

Any suggestions are greatly appreciated !


thanks again!
mike123

View Replies !

---

Save DTS Package Error: Unspecified Error
I'm getting a very unhelpful message when I attempt to save a change to an existing DTS package. The error simply says "unspecified error" and no changes are saved.

A bit of more info:
The package was initially created on a Windows 2000 active/passive cluster running SQL 2000 (at the time, SP3).

We created a new Windows 2003 active/active cluster and migrated the package to the new SQL Server (now running 2000 SP4).

I am able to open each task in the package with no errors (indicating to me that all the components are properly registered).

I AM able to save the package to the other active instance.

I get the same error message whether I attempt to save the package from Node1 or Node2 (logged in via terminal services).

No other package(s) exhibit this behavior.

Any thoughts or suggestions would be welcome. Disparaging comments about using DTS are not :D .

Regards,

hmscott

View Replies !

---

Prevent Duplicate Insert
How can I prevent duplicate inserts or entries to a table?
Thank you.
Note: I am using SQL Server and coding ASP.net pages in VB.

View Replies !

---

Prevent Duplication On UPDATE
Hello
I noticed a spelling mistake in the data in a column of several tables, I used the following syntax to alter the spelling:
UPDATE [dbo].[Prod_Cat]     SET  [ProdName]=N'merseyside'    WHERE ProdName = 'mmserseyside'
The above code correctly updated the spelling error, but it also inserted a new row with the corrected data. 
So I found myself with two Identical rows containing the corrected information. I had to manually delete the extra row. Because if I had put in a DELETE statement, I would have then lost both rows.
What do I need to do to prevent this happening next time.  As I find that I need to update the names of some products, but I don't want to duplicate them.
Thanks
Lynn

View Replies !

---

How Do I: Prevent Race Condition?
I want to be able to read and update a value in the database without entering a race condition.
For example:
User #1 reads a row from the database, changes a value then writes the value back.
User #2 reads the same row AFTER user #1 has read it, but BEFORE user #1 writes it back. User #2 then changes the value and writes it back, overwriting the value that user #1 wrote.
I thought I could do this with transactions, but it just makes user #2 wait until user #1 is done writing before user #2 can write. It doesn't stop user #2 from reading while user #1 has it out.
Does that make sense?

View Replies !

---

Prevent Duplicate Records
I have a web form that I use to insert data into a sql database. I want to know how to prevent inserting duplicate records into the database. Thanks.

View Replies !

---

How To Prevent SQL Injection Attacks
Hi,

On my site I have a simple textbox which is a keyword search, people type a keyword and then that looks in 3 colums of an SQL database and returns any matches

The code is basic i.e. SELECT * FROM Table WHERE Column1 LIKE %searcg%

There is no validation of what goes into the text box and I am worried about SQL injection, what can I do to minimize the risk

I have just tried the site and put in two single quotes as the search term, this crashed the script so I know I am vunerable.

Can anyone help, perhaps point me in the direction of furthur resources on the subject?

Thanks

Ben

View Replies !

---