hmm,

what about having a word with the SAN engineer.

are there any quotas on directory contents? or any restrictions outside of SQL?

the other obvious thing to check is file...

i've tried that one before.

version control becomes an absolute nightmare. and you then take on all the problems of having enough connectivity to replicate to multiple sites as a background...

is anything coming up in the error logs?

is it possible to change the database to store hyperlinks to the file instead of using BLOBS?

what recovery mode are you using? if...

hell, host the site yourself.

if you only have that number of customers a normal ADSL line should do the business. just make sure you geta static IP

then you can...

try manually running an XP_SENDMAIL with the exact data that SQL would use.

this may not be SQL server, but something else picking up the email due to the content.

as...

what method are you using to write the record to the server?

can you post the trigger contents?

proboably, but it can be done as long as you are carefull.

if you can establish one site first and then try some test connectivity directly between the SQL servers...

i can't see any problems changing the MDP on a regular basis as long as you make sure that other processes aren't affected.

i suppose it will give you time...

looks like your only hope is to create your own form of replication,

use update insert and delete triggers to drip feed data between sites (use linked servers to keep...

there are a couple of ways of doing it

but i prefer

use mydatabase

go

select count (*) from sysfiles where maxsize -1 and (size/maxsize)>0.85

this will tell you how many files are over the...

what was the reason for changing in the first place?

if it was a particular query or stored procedure that was causing the problem then you should try and correct that...

ok - just a few more questions, and hopefully we should be able to come up with some good ideas

what sort of link do you have between the 2 database...

what have you used as declarations for the recordset objects?

for example

Set mrstCalc = mdbCalc.OpenRecordset("tabExpectedIncomeCalc")

are you explicitly specifying ADO recordsets?

i think we can manage that.

watch this space in the next few days.

so what you're trying to do is replication between two ISPs

do you have any ideas about conflict management? what if the same record is changed at the same time on...