Hi Thanks for the response.

W2003 Std only allows 32Gig if you go down the 64bit route, as I will be using SQL 2000 Enterprise 32 bit (64 bit causes too...

Thanks

I finally managed to get the Snapshot working from 2005 to SQL express 2008.

Cheers

Andy:-)

It is only returning between 1 and 5 records per enquiry, and the servers are linked. In addition they are on the same hub in the computer room....

Good Morning

Thanks for the input. The database has got some spare capacity but only 400meg, otherwise it is full of data

DBName...................distribution....................distribution

Tablename..................MSsnapshot_history........MSmerge_history

row...............................7992770.....................9983480

reserved.....................1802480 KB.................2781976 KB

data..........................1515984 KB.................2495016 KB

IndexSize.....................261472 KB...................286712 KB

Unused..........................25024 KB........................248 KB

These...

Many thanks for that, it was exactly what I was looking for

Cheers

Andy