Thanks dude..it was my application tool that was causing the issue . Its checked

Thanks Eben

At any given point of time my E drive which has a total capacity of 400 Gb has 40 GB of free space...

Its not a clustered server and there are...

gets rebooted when run DBCC Check DB too.....

nope its not a cluster server ...its stand alone only....

just add this in the step1 of your job step

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSRun" \

i didnt find any specified error in error log....

Hi find out the last log details in previous error log....

2009-03-30 21:24:19.84 spid53 DBCC CHECKTABLE (Chemmate.dbo.MAINVALIDATION_UNSUPPORTED) executed by sifydba found 0 errors and repaired 0 errors. ...

Guys,

This is my error log when i ran the check table statement

command used is : DBCC CHECKTABLE ('tablename')

Ran this command individually against each of the tables.

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

2009-03-30 20:48:58.40 spid54 ...

Rather than the following, there is no clue to anything as it comes again to the startup of the Log.

SQL agent logs :

2009-03-30 21:36:28 - ! [364] The Messenger service...

Also gail...

yes i cant lose data and so i cant use data loss option.

Let me know the ways to find if the tables are corrupted as if i run the...

Guys,

I am not able to find anything abnormal with the SQL erorlogs and the System eventlogs. SQL logs are normal

I am not certain on the details of the table...

Hi,

Let me know if you were able to resolve this mail shut down issue, I am still f acing the problem and my issue resembles the same except that I...

Thanks a lot....

Can i also know how to find which database or session or SP or SQL leaves temporary table without properly removing itself from tempdb.

I can find that in...

Ok....solution to my current problem please,..:blink:

I also face a similiar problem with my DTS package.Can someone say whether the windows patch i had installed on the server could have lead to this error.

There was no...