what i should I have 4 tables, 2 tables were truncated by table 3 and 4 giving this error

Thank you

RESPECT PEOPLE

I read the books, you have so much time on you,so lucky

When I go to sql jobs and trying to set notofications under email, there is no option to type email,looks like I have to enter somewehere else, where is that...

I work with both!!

What is service account?

But do I need to create seperate sql account in sql server to run, if yes what setting needs to be check for it?Thank you

Thank you

I can't re name table, I need to leave 200 million records and that table and I need to delete 190 millions records.

I created store procedure:

BEGIN

SET ROWCOUNT 1000000;

...

is it dbcc shrink

Yes,trans log backed up

My .bak is 20.1 GB, my last for today morning .trn 655 KB

this is for transaction jobs:EXECUTE master.dbo.xp_sqlmaint N'-PlanID D3176901-93DB-4538-8A12-35D337C7C70D -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "F:\MSSQL\BACKUP" -DelBkUps 1DAYS -CrBkSubDir -BkExt "TRN"'

this is for full backup:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID D3176901-93DB-4538-8A12-35D337C7C70D -WriteHistory -VrfyBackup...

I have transaction job occurs every 4 hours