Database Monitoring

Can anybody help me with the following on my MS SQL Server 2000 database.

1. All tables should have a lastModificationDate column. Any changes and inserts should have the system time updated with a trigger or so. We shouldnt be inserting the value using SQL statements into this column.

2. There shouldnt be any deletes on the table. Any deleted records should be marked as inactive or deleted, so it wont come in queries, but should be physically present in the tables.

3. A modification log table, which will carry the table name, the column identifier, user modified, old value and the timestamp.

Thanks
Kishore1. I dont think u need to have triggers for this - just create ModificationDate field & set it as NOTNULL & Default value as CurrentDate

2. Do u want this also to happen in backend with out frontend access then... go for triggers for delete statement and set that to 1 or 0, but anyway u need to change the 'select' query to check the Falg feild.

3. Do u want this to happen in trigger... I would say pls dont go for that... I doesnt know well about ur appln... but if it have Millions of data and for maintenance purpose u run a backend query(update/delete with trigger attached)... just imagine how this trigger will work...

Database Maintenance Error 21268

SQL Server 2000 on Win2003
Database Maintenance/Optimizations generates the following error in the log:
Error 21268: [SQL-DMO]Row or column specified is outside the range of the
specified query result set.
Which "specified query result test" is this message speaking about?
Many thanks for your help,
Dan
Hello,
rename backupfolder according:
http://support.microsoft.com/default...b;en-us;326485
regards,
Henk
"Dan" <dan@.milton.co.uk> wrote in message
news:43e261b4$0$82641$ed2619ec@.ptn-nntp-reader03.plus.net...
> SQL Server 2000 on Win2003
> Database Maintenance/Optimizations generates the following error in the
> log:
> Error 21268: [SQL-DMO]Row or column specified is outside the range of the
> specified query result set.
> Which "specified query result test" is this message speaking about?
> Many thanks for your help,
> Dan
>