Thanks a lot.Ya it was simple.But When I did it before it was scripting in some other format which I could not copy..

Now when I do it ,

It gives a...

Ya...

This is the plan the company wants to execute-

1. A full database backup on Sunday night.

2. A set of transaction log backups'll be  made every four hours during the...

Everything is back to normal now.That data is stored in some staging tables too.Package ran for 8 tables.Only 2 tables were not in staging ..So we had to work again...

Oh That's OK...I didn't even think it that way..

But ya..This problem is solved now by bringing data from some other resources ...and the company thinks to bring in new stratagies...

Thanks...

Is there some way to find  all those stored procedures

 for which we are getting their  old names in the script.

Thanks.

Great !! I think my problem is solved.

Thanks .

Thanks a lot for this code. Now I See that there are 2 stored procedures in the script which

are having the same name(Which is not the case with the...

Thanks for the valuable advice..I didn't know about the truncate log  option as I am a sql programmer.

But know I know everything about it.

And...

Thanks,

The database is set up with 'truncate transaction log with checkpoint' option.So may be thats why we dont have earlier transaction logs.

We have the back up for Friday night but the needed work is for yesterday.So Its important to recover yesteday data till 3 pm. All mdf and ldf files are...