Thanks all, I ended up using net start and stop as scheduled tasks. Seems to be working fine.

Cheers,

Terry

Hi,

Unfortunately this method includes a drop and create statement for all tables. Im pretty sure that no drop index command is even performed because the tables are dropped.

Thanks,

Terry

Ooooh....I like that suggestion...Tell me more...do you have a good starting point(other than BOL cause that where Im looking now).

Cheers,

Terry

Thanks Ken,

I'm trying a different approach using DTS...although I'm coming across a few dramas already in regards to using Global variables.

So look out for my post in the DTS section.

Cheers,

Terry

Hi All,

Many thanks to all suggestions. I checked and performed all the obvious such as updating indexes, and setting of db options.

However, I found that the database 'sorted' itself out...

Why do I think that?? Maybe because an attempted restore of a user database failed altogether and I don't have any explanation except that the master.dbo.sysdatabase tables reference to itself...