Thanks for reply, As I said I already did the query(T-SQL) to get the Daily, Weekly, Report, But I need them in "1" view so maybe I need to use...

Sorry for not mentioning the version, I'm using SQL Server 2000

I think your right that it is a shotgun approach. I will follow your suggestion to start on weekly index maintenance plan. I think I should talked to that programmer...

Thank you for the reply,I just consult this question because it really seems theres something bad with that codes, honestly that code was just given by the programmer that made...

THANK YOU VERY MUCH TO YOU ALL!!

Im sorry I did not understand the first one that was suggested to me. I'm starting to read online books regarding trigger. Again...

Alright I will explain more of my issue on this task.

First Im not allowed to modify the software that can do deletion of data in our SQL server. So when...

Thank you for the responce and sorry I did not clear these things. This is what I want in my Trigger.

CREATE TRIGGER [TRIGDelete] ON [dbo].[TableA]

FOR DELETE

AS

INSERT INTO TableB (Column List)

SELECT...

Thanks for the reply

I already did that but unfortunately the record I want is not on that backup.

Can I use .Log? to Rollback deleted rows.

Thank you for the reply...

It's kind of weird thing that happens to my views becase it's running for about a year now. And this is the first time it happened,...

Thank you for the reply..

CREATE TRIGGER [TRIGDelete] ON [dbo].[TableA]

FOR DELETE

AS

INSERT INTO TableB (Column List)

SELECT Column List

FROM deleted

GO

On this trigger, How will I know of what data was deleted? For ex....

Thank you very much for the reply but on this query

select * from master..syscacheobjects

where objtype = 'ADHOC'

It has a field of sql but how will I know on when the...

Thank you!!! It was really a big help.:-)

THANK YOU SO MUCH! :w00t: This solve my problem!!! I've been working for this since yesterday. It really gives me headache. Thanks again!!