What is the status column reflects?

Do you want to eliminate duplicate records?

Check the following link

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Check the following link

http://weblogs.sqlteam.com/jeffs/archive/2008/07/31/week-days-between-two-dates.aspx

Check following link

http://msdn.microsoft.com/en-us/library/aa262728.aspx

You can create a role which is having data_writer permission and a member to that role

Check following link

http://groups.google.nl/group/microsoft.public.sqlserver.programming/browse_thread/thread/46512c2691da4607/6743f4aea485c6d1

Do you mean to say you want to debug to SP?

You will get only user name.

Check the following link can know about tempdb

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx

What is the recovery mode? If it is not simple put in simple recovery mode and check,

Check with the dbcc checkdb for any errors.

Do you have enough disk space for backup?

Please post log error message fully.

Check the following link

http://msdn.microsoft.com/en-us/library/ms144287(SQL.90).aspx

SET QUOTED_IDENTIFIER OFF

IF EXISTS(select * FROM master..sysdatabases where [name] ='pubs')

begin

use pubs

...

Create job for backup.

select convert(varchar(16),getdate(),121)+':00:00'