This code reindexes all tables and seems to work fine for as long as no one is on the system. So run about 1am

Rgds

BillD

SET NOCOUNT ON

DECLARE table_object CURSOR FOR

SELECT

'Sirius..'...

KlK,

The reason for this is Money.

Server 1. Just doesnt need Enterprise edition.

Server 2. Now has an instance that is used on the web and also doesnt need Enterprise...

- Many thanks, the machine has 4 processors and 5GB of ram but with 2 instances of SQL Server.

So I presume I just...