SQL Exception Generated By Server

Nov 11, 2006

HI all,

if this issue has been solved, please provide me the post, or I've put this issue in a wrong category please let me know.

The following is my code:

DateTime dtBFWNow = DateTime.Today;

String dtBFW_range1 = dtBFWNow.AddDays(-7).ToShortDateString();

String dtBFW_range2 = dtBFWNow.AddDays(3).ToShortDateString();

SqlDataSource1.SelectCommand = "SELECT * FROM [MORTGAGE] WHERE ([BringForwardDate] is not null) and ([BringForwardDate]>= '" + dtBFW_range1 + "' and [BringForwardDate] <= '" + dtBFW_range2 + "')";

lblHeader.Text = "Bring Forward Reminders Due From '" + dtBFW_range1 + "' To '" + dtBFW_range2 + "'";

lblHeader.ForeColor = System.Drawing.Color.FromName("#000000");

GridView1.DataBind();

When I compiled, the following exception occurred:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

and the exception points right at the line: GridView1.DataBind() 

I use the webhost4life as my server provider.  My codes run fine with the server.  I mean I uploaded my program to the server, set up and run the program online, everything is fine. 

But on my PC it gives me the above exception.  I can't compile my code.  There must be some sort of setting somewhere in my PC that can't handle the exception.

Please help.

Regards.

Joey.

 

View 2 Replies


ADVERTISEMENT

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

Jan 18, 2008



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 2 Replies View Related

SqlDumpExceptionHandler: Process 145 Generated Fatal Exception

Apr 23, 2007

Hello,

we've recently upgraded a database from sql 2000 to sql 2005. There is one report that creates a fatal exception and sql dump whenever it is run. It ran without error in 2000.



The report is using several sql views and one stored proc. Running these individually via sql don't cause any errors. All other reports and processes run fine in 2005.



I'm at a loss as to what to check next. Any ideas?



Please let me know if I can provide any more details to help troubleshoot the issue.



thanks,

joe

View 5 Replies View Related

DTS Package - Provider Generated Code Execution Exception: EXCEPTION_ACCESS_VIOLATI

Feb 23, 2006

When running a step within my DTS package I'm receiving the following error - "Provider generated code execution exception: "EXCEPTION_ACCESS_VIOLATION".

I think it may be something to do with my global variable, but I'm not sure as I'm pretty certain I've set it all up correctly.

Below are screenprints showing my settings.

http://img153.imageshack.us/my.php?image=19tv1.jpg

http://img153.imageshack.us/my.php?image=25wz1.jpg

http://img153.imageshack.us/my.php?image=39pf.jpg

http://img164.imageshack.us/my.php?image=43nx.jpg

http://img164.imageshack.us/my.php?image=51ao.jpg

http://img164.imageshack.us/my.php?image=64lo.jpg

http://img164.imageshack.us/my.php?image=71yn.jpg

Any advice of fixing this would be greatly appreciated.

View 6 Replies View Related

Error: 17310: User Request Generated A Fatal Exception (AND I KNOW WHY)

Nov 15, 2007

Hello,

Just yesterday I implemented SqlCacheDependencies on my ASP.NET 2.0 web site for SQL Server 2005. My SQL Server 2005 database is in mode 90, mirrored with a second database server. Now I am getting Error 17310 while running very simple statements, but only on a specific table.

We have a table called "tblSchools" which, due to negligence and incompetence, has a maximum size of over 8,000. I plan on fixing that eventually, by splitting all the long varchar(2048) fields off into other tables.

I wanted to use SqlCacheDependencies on this table, for every single column. So I created a DateTime column called LastChanged and created a trigger. I am using LastChanged as a DateTime type instead of a TimeStamp/RowVersion type because I thought it would be more useful.

Here are the changes made:
---------------------------

-- Adding the column...
ALTER TABLE tblSchools
ADD
LastChanged DateTime Null
GO

-- The program uses this stored procedure to watch the "LastChanged" column.
CREATE PROCEDURE [apCacheWatchSchool]
@SchoolID int
AS
select LastChanged from dbo.tblSchools where SchoolID = @SchoolID
GO

-- Any updates on the table cause the LastChanged column to be updated with getdate()
CREATE TRIGGER [UpdateLastChanged_TS]
ON [dbo].[tblSchools]
AFTER INSERT,UPDATE
AS
BEGIN
SET NOCOUNT ON;
update [dbo].[tblSchools]
set LastChanged = getdate()
where SchoolID in (select SchoolID from inserted);
END
GO

---------------------------

After adding this column and the trigger and s-proc, any update to any row in tblSchools fails with error 17310. It CANNOT set LastChanged to anything. It has to remain NULL. I was able to perform the following operation (as long as the tblSchools.LastChanged updating trigger [UpdateLastChanged_TS] was disabled): "update tblSchools set SchoolName = 'ZZZZ' + SchoolName where SchoolID = 185" -- so, it's not some kind of row length limit. I think it's a limit on # of columns that can be dealt with. I don't really know.

I don't know where the problem is occurring. I am just telling you why. I got around the problem (temporarily) by simply having the trigger update a DateTime column in another table, and having the SqlCacheDependency watch that column in the other table. No biggie.

As for moving some of the enormous varchar columns off of tblSchools... I don't really care enough. I guess that's why it's been like this for so long.

So, my problem is fixed, I just wanted to submit this bug report so you can at least fail gracefully in the next version of SQL Server.

I have the log/txt/mdmp files available, and can provide them upon request; they're too big for this form, sorry. Please contact me at plushpuffin AT wwddfd.com if you have any questions.

View 1 Replies View Related

SqlDumpExceptionHandler: Process 80 Generated Fatal Exception C0000005 EXCEPTION_ACCESS_VIOLATION

Sep 26, 2007

Team
I keep getting this error every so often in the SQL Server(2005.90.3054.00). 2005/SP2/Hot Fixes. Windows Server 2003 SP2. I have researched the web, every one seems to have the same question and nobody seems to have an answer.
This somehow does not show up in the Profiler. The apps work normally too.
It is a huge eye sore in the LOGs.
=================
BugCheck Dump
=================

This file is generated by Microsoft SQL Server version 9.00.3054.00 upon detection of fatal unexpected error. Please return this file, the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is AT/AT COMPATIBLE.
Bios Version is COMPAQ - 2
Current time is 15:52:36 09/27/07.
8 Intel x86 level 15, 2694 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 2.

Memory
MemoryLoad = 93%
Total Physical = 9727 MB
Available Physical = 638 MB
Total Page File = 13613 MB
Available Page File = 4573 MB
Total Virtual = 2047 MB
Available Virtual = 246 MB
***Stack Dump being sent to E:Microsoft SQL ServerMSSQL.1MSSQLLOGSQLDump1331.txt
SqlDumpExceptionHandler: Process 91 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 09/27/07 15:52:36 spid 91
* Exception Address = 0100E88E Module(sqlservr+0000E88E)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0000000C
* Input Buffer 36 bytes -
* s p S e l e c t 10 00 73 00 70 00 53 00 65 00 6c 00 65 00 63 00 74 00
* I n t e r n e t 49 00 6e 00 74 00 65 00 72 00 6e 00 65 00 74 00 00 00
* MODULE BASE END SIZE
* sqlservr 01000000 02C0AFFF 01c0b000
* ntdll 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* MSVCR80 78130000 781CAFFF 0009b000
* msvcrt 77BA0000 77BF9FFF 0005a000
* MSVCP80 7C420000 7C4A6FFF 00087000
* ADVAPI32 77F50000 77FEAFFF 0009b000
* RPCRT4 77C50000 77CEEFFF 0009f000
* Secur32 76F50000 76F62FFF 00013000
* USER32 77380000 77410FFF 00091000
* GDI32 77C00000 77C47FFF 00048000
* CRYPT32 761B0000 76242FFF 00093000
* MSASN1 76190000 761A1FFF 00012000
* MSWSOCK 71B20000 71B60FFF 00041000
* WS2_32 71C00000 71C16FFF 00017000
* WS2HELP 71BF0000 71BF7FFF 00008000
* USERENV 76920000 769E1FFF 000c2000
* opends60 333E0000 333E6FFF 00007000
* NETAPI32 71C40000 71C96FFF 00057000
* SHELL32 7C8D0000 7D0CDFFF 007fe000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* comctl32 77420000 77522FFF 00103000
* psapi 76B70000 76B7AFFF 0000b000
* instapi 48060000 48069FFF 0000a000
* CLUSAPI 74DE0000 74DF1FFF 00012000
* ole32 77670000 777A8FFF 00139000
* OLEAUT32 77D00000 77D8AFFF 0008b000
* RESUTILS 74EF0000 74F02FFF 00013000
* sqlevn70 4F610000 4F7B8FFF 001a9000
* SQLOS 344D0000 344D4FFF 00005000
* rsaenh 68000000 68034FFF 00035000
* AUTHZ 76C40000 76C53FFF 00014000
* MSCOREE 79000000 79044FFF 00045000
* msv1_0 76C90000 76CB6FFF 00027000
* iphlpapi 76CF0000 76D09FFF 0001a000
* kerberos 61FF0000 62047FFF 00058000
* cryptdll 766E0000 766EBFFF 0000c000
* schannel 76750000 76776FFF 00027000
* COMRES 620B0000 62175FFF 000c6000
* XOLEHLP 62180000 62185FFF 00006000
* MSDTCPRX 62190000 62208FFF 00079000
* msvcp60 62210000 62274FFF 00065000
* MTXCLU 62280000 62298FFF 00019000
* VERSION 77B90000 77B97FFF 00008000
* WSOCK32 71BB0000 71BB8FFF 00009000
* DNSAPI 76ED0000 76EF9FFF 0002a000
* winrnr 622F0000 622F6FFF 00007000
* WLDAP32 76F10000 76F3DFFF 0002e000
* rasadhlp 62320000 62324FFF 00005000
* hnetcfg 62330000 62389FFF 0005a000
* wshtcpip 71AE0000 71AE7FFF 00008000
* security 62890000 62893FFF 00004000
* msfte 63070000 632C8FFF 00259000
* dbghelp 632E0000 633F4FFF 00115000
* WINTRUST 76BB0000 76BDAFFF 0002b000
* imagehlp 76C10000 76C37FFF 00028000
* dssenh 68100000 68126FFF 00027000
* NTMARTA 77E00000 77E20FFF 00021000
* SAMLIB 7E020000 7E02EFFF 0000f000
* ntdsapi 766F0000 76703FFF 00014000
* xpsp2res 63C00000 63EC4FFF 002c5000
* CLBCatQ 777B0000 77832FFF 00083000
* sqlncli 63ED0000 640F3FFF 00224000
* COMCTL32 77530000 775C6FFF 00097000
* comdlg32 00940000 00988FFF 00049000
* SQLNCLIR 64210000 64242FFF 00033000
* msftepxy 64AD0000 64AE4FFF 00015000
* xpsqlbot 64B30000 64B35FFF 00006000
* xpstar90 64F70000 64FB8FFF 00049000
* SQLSCM90 64FD0000 64FD8FFF 00009000
* ODBC32 64FF0000 6502CFFF 0003d000
* BatchParser90 65030000 6504EFFF 0001f000
* ATL80 7C630000 7C64AFFF 0001b000


Thanks for your help in advance.
Paresh Motiwala
EDS, Boston, USA
The other half of the error message is in the second message of the same thread below.

The file is located here:

View 1 Replies View Related

Event ID: 17052 SqlDumpExceptionHandler: Process 57 Generated Fatal Exception C0000005 EXCEPTION_ACCESS_VIOLATION

Nov 15, 2007

I'm running SQL 2000 SP4 on a patched Windows 2003 SP2 server.
I keep getting the error:


Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 11/14/2007
Time: 3:51:13 AM
User: N/A
Computer: HOST20
Description:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.


Any idea what this is or what to do to fix it?

View 7 Replies View Related

Entity Framework: No Support For Server-generated Keys And Server-generated Values

May 23, 2008

Hello

I tried the Beta 1 of the service pack 1 to .net 3.5. If I try to add an entity (and try to save this), I get the Exception "No support for server-generated keys and server-generated values".

How can I add entities to my Sqlce- database?

I tried to give the id- column (primary key) in the database an identity, another time without identity, only primary key --> none of them worked. I always get the same error.

What do I have to change to make successfully a SaveChanges()?

Thanks for your help,
Gerald

View 21 Replies View Related

'((System.Exception)($exception)).Message' Threw An Exception Of Type 'System.NotSupportedException'

Jan 16, 2008

Greetings everyone, I am attempting to build my first application using Microsofts Sql databases. It is a Windows Mobile application so I am using Sql Server Compact 3.5 with Visual Studio 2008 Beta 2. When I try and insert a new row into one of my tables, the app throws the error message shown in the title of this topic.
'((System.Exception)($exception)).Message' threw an exception of type 'System.NotSupportedException'



My table has 4 columns (i have since changed my FavoriteAccount datatype from bit to Integer)
http://i85.photobucket.com/albums/k71/Scionwest/table.jpg

Account type will either be "Checking" or "Savings" when a new row is added, the user will select what they want from a combo box.

Next is a snap shot of my startup form.
http://i85.photobucket.com/albums/k71/Scionwest/form.jpg



Where it says "Favorite Account: None" in the top panel, I am using a link label. When a user clicks "None" it will go to a account creation wizard, and set the first account as it's primary/favorite. As more accounts are added the user can select which will be his/her primary/favorite. For now I am just creating a sample account when the label is clicked in an attempt to get something working. Below is the code used.


private void lnkFavoriteAccount_Click(object sender, EventArgs e)

{

FinancesDataSet.BankAccountRow account = this.financesDataSet.BankAccount.NewBankAccountRow();

account.Name = "MyBank Checking Account";

account.AccountType = "Checking";

account.Balance = Convert.ToDecimal("15.03");

account.FavoriteAccount = 1;//datatype is an integer, I have changed it since I took the screenshot.

financesDataSet.BankAccount.Rows.Add(account);
//The next three lines where added while I was trying to get this to work.
//I don't know if I really need them or not, I receive the error regardless if these are here or not.



this.bankAccountTableAdapter1.Update(financesDataSet);

this.financesDataSet.AcceptChanges();

refreshDatabase();

}


the refreshDatabase() code is here:


private void refreshDatabase()

{

this.bankAccountTableAdapter1.Fill(this.financesDataSet.BankAccount);

//Aquire a count of accounts the user has

int numAccounts = financesDataSet.BankAccount.Count;

//Loop through each account and see which one is the primary.

for (int num = 0; num != numAccounts; num++)

{
//Works ok in frmMain_Load, but when my lnkFavoriteAccount_click calls this, it throws the error.

if (this.financesDataSet.BankAccount[num].FavoriteAccount == 1)

{
//Display the primary account on our home page. User can click the link label & be taken to their account register.

this.lnkFavoriteAccount.Text = this.financesDataSet.BankAccount[num].Name.ToString();

this.lnkFavoriteFunds.Text = this.financesDataSet.BankAccount[num].Balance.ToString();

break;

}

}

}


and my form_load code

private void frmMain_Load(object sender, EventArgs e)

{

refreshDatabase();

}


So, when I click on the lnkFavoriteAccount label, and my new row gets added, the app stops at the following line in my DataSet.Designer

[global:ystem.Diagnostics.DebuggerNonUserCodeAttribute()]

public byte FavoriteAccount {

get {

try {

return ((byte)(this[this.tableBankAccount.FavoriteAccountColumn]));

}

catch (global:ystem.InvalidCastException e) {
//Stops at the following line, this error was caused by 'if (this.financesDataSet.BankAccount[num].FavoriteAccount == 1)'

throw new global:ystem.Data.StrongTypingException("The value for column 'FavoriteAccount' in table 'BankAccount' is DBNull.", e);

}

}

set {

this[this.tableBankAccount.FavoriteAccountColumn] = value;

}

}


I have no idea what I am doing wrong, all of the code I used I retreived from Microsofts help documentation included with VS2008. I have tried used my TableAdapter.Insert() method and it still failed when it got to

if (this.financesDataSet.BankAccount[num].FavoriteAccount == 1)

in my refreshDatabase() method it still failed.

When I look, the data has been added into the database, it's just when I try to retreive it now, it bails on me. Am I retreiving the information wrong?

Thanks for any help you guys can offer.

Johnathon

View 1 Replies View Related

The Script Threw An Exception: Exception Of Type 'System.OutOfMemoryException' Was Thrown.

Jan 31, 2007

Hi,

I got an strange problem with one of my packages.

When running the package in VisualStudio it runs properly, but if I let this package run as part of an SQL-Server Agent job, I got the message "The script threw an exception: Exception of type 'System.OutOfMemoryException' was thrown." on my log and the package ends up with an error.

Both times it is exactly the same package on the same server, so I don't know how the debug or even if there is anything I need to debug?

Regards,

Jan

View 2 Replies View Related

How To Delete Job Generated From Master Server

Nov 12, 2001

Hi everybody.
Job was generated from from master server to run on target server
Target server does not exist any more
I want to delete this job but geeting error
"Error 14247 can't add ,update or delete job that generated from MSX server"

View 2 Replies View Related

Custom Auto Generated Sequences With Server?

Aug 31, 2014

can i create Custom Auto-Generated Sequences with SQL Server like DD-0001,DD-0002,DD-0003...... to DD-000........

View 1 Replies View Related

SQL 2012 :: Server Generated A New SPID With Same Type Of Query

Feb 25, 2014

There are times when I either compile a stored procedure, or right now as I am creating indexes on tables, when sp_who2 shows a SPID assigned to my name that I do not currently have opened in SSMS. When I check the statement with dbcc inputbuffer it shows a query hitting many of the system views. Earlier this week, someone tried killing one of these SPIDS and SQL Server generated a new SPID with the same type of query.

View 5 Replies View Related

SQL Server 2014 :: Retrieving All Error Messages Generated By A Command

Jul 17, 2014

Some T-SQL commands can fail with multiple errors. For example, if you try to disable a primary key constraint using ALTER TABLE t1 NOCHECK CONSTRAINT PK, you will get messages like:

Msg 11415, Level 16, State 1, Line 341
Object 'PK' cannot be disabled or enabled. This action applies only to foreign key and check constraints.
Msg 4916, Level 16, State 0, Line 341
Could not enable or disable the constraint. See previous errors.

However, in the code below, only the last message is printed. How can I print all the error messages?

USE tempdb;
CREATE TABLE #t1(c1 INT CONSTRAINT PK PRIMARY KEY);
BEGIN TRY
ALTER TABLE #t1 NOCHECK CONSTRAINT PK;
PRINT 'Primary key disabled'
END TRY
BEGIN CATCH
PRINT ERROR_MESSAGE();
END CATCH

View 4 Replies View Related

RA_Setup_IO [Bucket: 0] [slot: 0]: Process 4 Generated Access Violation; SQL Server Is Terminating T

Feb 19, 1999

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 2 Replies View Related

Trying To Connect To Northwind Database, On SQL Compact Server 3.5, An Error Generated, 'The Event Log Is Full'

Dec 26, 2007

View 1 Replies View Related

Exception Handling On Linked Server?

Mar 6, 2009

I am trying to handle exceptions using try catch with remote database.

I am writing the following code which works fine if login locally but when I am trying to do the same on linked server its not being caught in try..catch block.

The procedure I am writing to raiserror

create proc CustomError
as
RAISERROR ('db error', 16, 1);

I am calling the above procedure in local database using following code

BEGIN TRY
exec CustomError
END TRY
BEGIN CATCH
select ERROR_MESSAGE() as ERROR_MESSAGE;
END CATCH;
GO

and it works perfectly. I am able to catch the error in catch block.

and i m getting the following result
db error

but when i am trying to do the same on linked server the code doesn't take me to catch block. I am getting following error while executing the code

go
BEGIN TRY
exec [192.168.0.50].[BM].dbo.CustomError
END TRY
BEGIN CATCH
select ERROR_MESSAGE();
END CATCH;
GO

where [192.168.0.50] is a linked server name and BM is the database name and custom error is my sp which is on remote server.

its giving me following error

Msg 50000, Level 16, State 1, Procedure CustomError, Line 11
db error

View 1 Replies View Related

Sql Server Severity And Exception Handling

May 29, 2007

I'm creating a class that will wrap a SqlException and will offer the developer a way of determining how to proceed in handling the exception by offering a suggestion of retrying, revalidating the data, and/or calling the entire process a no go.

One of the ways i've come up with to accomplish this is by using the severity (SqlException.Class) to assist in making a suggestion to the developer.

I'm hoping to get some feedback from the developers who use this forum if they feel severity is or is not the way to go, and also to offer any other ways of accomplishing that they can come up with.

Thanx

AJ

View 3 Replies View Related

SQL Server Throw Timeout Exception

Jun 5, 2007

This is my code connect to SQL Server
SqlConnection con = new SqlConnection("Data Source=OIT;Initial Catalog=big_db;User ID=sa; Password=");
SqlDataAdapter cmd = new SqlDataAdapter("select * from myDB", con);
SqlCommand sqlCmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.Fill(dt); // It throw exception
When myDB table have a lot of data, it throw exception like this : "It reached the time-out. Did the time-out period pass before completing the operation or the server doesn't respond. ". I config TCP/IP for SQL Server is Enable, but it throws SqlException too.
How can I do? Help me please!!!

View 2 Replies View Related

ASP.Net Server Setup Exception (reqsql.exe)

Jul 12, 2006



I was attampting to add application services to a remote server to my ASP database and received and exception.

Setup failed.

Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 8152 and the SqlException message is: String or binary data would be truncated.

----------------------------------------
Details of failure
----------------------------------------

SQL Server:
Database: [consecdevdb]
SQL file loaded:
InstallCommon.sql

Commands failed:

CREATE TABLE #aspnet_Permissions
(
Owner sysname,
Object sysname,
Grantee sysname,
Grantor sysname,
ProtectType char(10),
[Action] varchar(20),
[Column] sysname
)

INSERT INTO #aspnet_Permissions
EXEC sp_helprotect

IF (EXISTS (SELECT name
FROM sysobjects
WHERE (name = N'aspnet_Setup_RestorePermissions')
AND (type = 'P')))
DROP PROCEDURE [dbo].aspnet_Setup_RestorePermissions


SQL Exception:
System.Data.SqlClient.SqlException: String or binary data would be truncated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)


Can anyone help me with this?

View 3 Replies View Related

SQL Server 2005 Transaction Exception

Apr 19, 2007

Dear All,
I am getting SQL Server 2005 unable to resume transaction Exception


Please guide and help


Thanks,
Waheed.

View 2 Replies View Related

Timeout Exception On Sql Server Thru Website..

May 20, 2008



Hi,
I have a website where the user uploads DBF files and then i am calling a sproc to scrub the data and put them from the staging database to the production database. If the folder size small may be less that 6 it transfers the data from the staging database to the production.. But if the size of the folder is big.. more the 6 mb i get an timeout exception.. But i know the data is been put in few tables in the production databse..

for eg... if the size of the file is 33mb it takes around 15 mins or so for the sproc to process . I have tried setting the connect and commd timeout whcih has not helped.. I tried increasing the server.script time and it fails too..

this is the error in my event viewer


Error: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

No Changes made to the ClientPlan table.

Inserting records(s) in ClientPlan table.

No Changes made to ClientPlan table.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)

at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)

at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)

at icc.BaseClasses.DL.DLImportPlan.Import(Int32 ClientId, DateTime StartDate, DateTime EndDate, Int32 UserId) in C:Documents and SettingskroslundMy DocumentskareniccPlanStatementsiccImportDLDLImportPlan.cs:line 120

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


any help will be appreciated.

Regards
Karen

View 15 Replies View Related

Exception (Unable To Connect To SQL Server Database).

Jul 4, 2006

hi... i am new to ASP2.0 and i was trying to use the properties associated with the profile class.
here what i was trying to do...
in "Web.config"
<anonymousIdentification enabled="true"/>
     <profile enabled ="true">
         <properties>
            <add name="p1" allowAnonymous ="true"/>
          </properties>  
   </profile>
in "Default.aspx.cs"
protected void Page_Load(object sender, EventArgs e)
{
   if (!Page.IsPostBack) {
       Profile.p1 = "Welcome";
      LabelResult.Text = Profile.p1;
   }
   else{
      Profile.p1 = "you'v been here";
      LabelResult.Text = Profile.p1;
   }
}
but i had the exception ( Unable to connect to SQL Server database) at  "App_Code.qzomymsu.0.cs"
public virtual string p1 {
get {
      return ((string)(this.GetPropertyValue("p1")));
}
set {
      this.SetPropertyValue("p1", value);
}
}
i know the problem has something to do with providers, and i want to store the values to an XML file.... thank you for helping.

View 1 Replies View Related

PLS HELP!!! Sql Exception: SQL Server Does Not Exist Or Access Denied

Nov 22, 2005

hI all,
   I have sql server 2000 installed on one machine running
windows server 2003 and using VS 2003 to code and run IIS 5.0 on
another machine running windows XP.
I'm getting the error: sql exception: SQL Server does not exist or
access denied.  But i tried using osql to connect to the sql
server from the XP machine and it works fine!
Can someone pls help me and tell me why i get this error for my webapp
but i can connect to the sql server with osql? Thanks in Advance

View 1 Replies View Related

Floating Point Exception In SQL Server 2000

Oct 26, 2006

Hi,

I got below error in the SQL Server Production Server and i checked in the microsoft site it needs to install SQL Server service pack 4 to resolve the
problem.

"A floating point exception occurred in the user process. Current transaction is canceled"

I need help that i want to reproduce this below problem in the SQL Server environment and tried several ways but no luck.

Please advise me how to reproduce the problem.

Would be appreciate your help.

Regards
Sathish

View 4 Replies View Related

HELP: SQL Server Is Terminating Because Of Fatal Exception C0000005

Feb 28, 2008



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 7 Replies View Related

SQL Server 2005 Timeout Expired Exception

Feb 13, 2006

Hi,

I have a program in C# that I used to run on Visual Studio 2000 and SQL Server 2000 without any problem.

Now I upgrade to VS2005 and SQL Server 2005 and get and exception while

insert via SqlCommand.ExecuteNonQuery(). the insert is after many inserts to the same table by that program. the CommandTimeout is set to 600 (in the 2000 version I never had to change the default value of 30 seconds).

the insert is through a connection that is kept open throughout the program for more than 30 minutes

the exception message is:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

the trace is:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()


Thanks for your help !

View 11 Replies View Related

SQL Server Is Terminating Because Of Fatal Exception C0000005.

Jun 30, 2007

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 2 Replies View Related

Strange SqlBulkCopy Exception With SQL Server 2005

Dec 10, 2006

Hello,

Wondering if anyone can help with a strange exception thrown while using the SqlBulkCopy class. I am using the class to transfer records from a DataTable in memory (approx 11,000 rows) into a SQL Server 2005 table.

Initially, the WriteToServer method was timing out a la KB913177 (http://support.microsoft.com/default.aspx/kb/913177), however I downloaded the hotfix, which eliminated this issue.

Now, I get a new exception thrown, as follows:

System.Data.SqlClient.SqlException: OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].Power_Avg'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)

I can't see anything wrong with the data I have. The column "Power_Avg" is of type "float". When forming the DataTable, I cast my data to float expcilitly in C#.

Other things to know:

I am using SQL Server Express (2005)
This same code works fine with SQL Server 2000 (MSDE)
My code makes all modifications inside a single transaction of type "Snapshot" (I have activated SNAPSHOT READ COMMITTED in the database)
I have not activated MARS in the connection

Any ideas / suggestions?

Thanks,

Nick

View 7 Replies View Related

SqlConnection Access Is Denied Exception With SQL Server 2005

Feb 21, 2006

Hi,I have a SqlConnection object with connection string, "Data Source=server1;Initial Catalog=CDCollection;User Id=joe;Password=11111."For User ID, I created a new user "joe" in the Management Studio.I tried to use this user, but sqlconnection threw an exception stating access was denied.I noticed that SQL Server 2005 has user accounts that you can create for the server and for the database, but I am confused by this.  How can a create a non-sa user account that I can give to the SQLConnection object that will work?  Do I need to create a user for the server and the same user for the database CDCollection?  I am not all familiar with SQL Server administration.Any help or leads would be appreciated.

View 3 Replies View Related

SQL Server 2012 :: Processing Of XML With OPENROWSET Gives Out Of Memory Exception

Jun 20, 2014

I have an XML file about 25MB. When I read it with openrowset it gives me 'System.OutOfMemoryException'. The machine I'm running has 16GB of RAM and memory is definetely not exceeded. When I run smaller XML files it works fine.

I've read that older versions of SQL Server had this problem and it was caused by the parser having limited amount of memory. Is this still the case? Is there a way to change this?

View 7 Replies View Related

The RPC Server Is Unavailable Exception - While Performing Web Farm Installation

Aug 28, 2007

Hi



I am trying to create a scale-out deployment of Reporting Services
2005 on a NLB cluster web farm by following the instructions in:
http://technet.microsoft.com/en-us/library/ms159114.aspx


However, when I install and configure Reporting Services on the second
node, and then go back to the first node to join the second node to
the scale-out deployment (as described in step 11 under 'To install
and configure the second report server instance"), I get the following
exception:


ReportServicesConfigUI.WMIProvider.WMIProviderException: An unexpected
error has occurred. Details:


The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) ---

> System.Runtime.InteropServices.COMException (0x800706BA): The RPC


server is unavailable. (Exception from HRESULT: 0x800706BA)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementScope.Connect()
at
ReportServicesConfigUI.WMIProvider.RSInstances.GetInstances(String
machineName)
--- End of inner exception stack trace ---
at
ReportServicesConfigUI.WMIProvider.RSInstances.GetInstances(String
machineName)
at
ReportServicesConfigUI.WMIProvider.RSInstances.GetInstance(String
machineName, String instanceName)
at
ReportServicesConfigUI.Panels.ClusterManagementPanel.ConfigureWebFarm(Objec­t
sender, RSReportServerInfo[] rsInfos)


I have spent hours searching for ideas, but so far no success. I have
also tried the following:


1. Enabling DTC access
2. Ensuring RPC service is running on both web and db servers
3. Installing WMI Windows Installer Provider
4. Granting admin rights on both db and web servers to the account
under which Reporting Services is running


Any help or suggestions would be greatly appreciated. It looks like
this should be a straight-forward task.


Thank you.

View 18 Replies View Related

File IO Exception Thrown When Trying To Access A CLR Assembly In SQL Server

Sep 5, 2007



I have been encountering a problem using a CLR Assembly in SQL server. The Assembly is one provided by Microsoft for an example on using Exchange web services with SQL server.

http://www.microsoft.com/downloads/details.aspx?FamilyId=D6924897-7B62-46FD-874E-24FB0FBA2159&displaylang=en#Requirements

Essentially what this package is, is a set of c# classes that access the Exchange 2007 Web Services via a set of user defined functions and views in MS SQL Server 2005.

We have not modified the code except to configure for our host environment.

We are able to register the assembly using the setup.sql file included. But when we try to access any of the views or use the functions we get the following error:


Msg 10314, Level 16, State 11, Line 10

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65551. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:

System.IO.FileLoadException: Could not load file or assembly 'exchangeudfs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=777b97dde00f3dbe' or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)

System.IO.FileLoadException:

at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)

at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

at System.Reflection.Assembly.Load(String assemblyString)

We have 3 testing environments. 2 Windows 2003 servers called test and test2. Also a single Windows 2000 server called test3. Test and test2 have a full suite installed on them, web server, exchange 2007, sql server 2005, they are also domain controllers for their own domains.

We get the above error on test and test2 but it runs fine on test3. Test and test2 represent what our production environment is like. Test3 was just part of our troubleshooting process.

We have tried a lot to make this work. Here are some details on the things we have tried.

The database is set up to allow CLR Assemblies. This is part of the setup.sql.

The assembly's permission is set to external_access.

We have gone all the way to setting the file permissions on the dll to full control to the Everyone group.

We have tried different accounts to run the SQL Service. We've tried the system account, the local admin account and a seperate user account.

The database we are using is a fresh brand new database. Therefore it does not fit into the bug reported in this article:
http://support.microsoft.com/kb/918040

I am really at a loss to where to go from here. Any ideas on why this 'out of the box' solution is causing us so many headaches would be appriciated.

Thanks,
Tim

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved