Notification sat up to under:that's how I created under Operators section: contains email account where to send it,which was created as a group account of different users

I re strted the agent and still the same situation, any ideas what else I need to check

it was enabled already

Thank you

I found in sql server logs someone ran backup, how can I check who is the user?Thank you

I got this error from transaction job failing:

Date4/8/2010 5:30:00 AM

LogJob History (SAVVIS Transaction Log Backup)

Step ID1

ServerS602561DC4EW30

Job NameSAVVIS Transaction Log Backup

Step NamePreform a Transaction Log Backup.

Duration00:00:04

Sql Severity16

Sql Message ID3262

Operator Emailed

Operator Net...

Preferably in sql

Thank you

This link is not working, do you know where I can find out, what happend when you enable this command?

They don't have sysadmin access level, I want to know if you enable is command is any access level changes for users? Thank you

Thank you it worked

I still get this error:

Cannot truncate table 'OrderFormHeader' because it is being referenced by a FOREIGN KEY constraint

I do have a where clause.

so I would do:

SELECT 1

WHILE @@rowcount > 0

DELETE TOP (10000) FROM table1 where date <=3/18/2009

right?

Thank you

Thank you very much

e