I need to know who has deleted the job?

Thanks for your reply but i am worried.I can see lot of users are connected to this user database.

I don't want to kill their spid. So is there any way...

I know the logic to find out,the logic is:

1.find the highest id per day.

2. Then find the max of (the original table -highest id table)

this way...

Even i was also thinking the same way,however i got stuck to implement this process as automated...

is it possible to export the event log to txt file automatically?

Is there any SQL command to read system event logs?

if It would help me create reboot report.

As server is running out of space i have to shrink either log files/database file.I can't take log back up because of space issue.

Thnks a lot. 🙂

Thanks for your reply.

Could you give me some example.

Thanks,I got my answer.

We are still having issue: All schedule job getting failed with this error message:

Windows Error - The data area passed to a system call is too small. This...

Thanks for your insight on this issue.I will run profiler traces on the server and let you know with my findings.

There is only one online application accessing the Database server.

Thanks,

Litu

When I am running the following command ,getting more than 600 rows,how I will check which article has problem..

select * from distribution.dbo.MSsubscriptions where subscriber_id=0

Thanks,

Litu Deb

Thanks for the query.

But sp_helparticle @publication = 'publication' , @article = '%'

this query show about all the article,From here how can I identify which article...

Thanks for your suggestion.

I would like to know is there any way to verify my tables statistics are updated.

Regds,

Litu Deb

Thanks a lot everyone.

I got now some idea about statistics.when I run the following command i can see the last updated date.

DBCC SHOW_STATISTICS ( )

So how to know when i...