This looks good. Thanks Andrew

yep..same server.so far everything is running fine. Wasn't sure if the recompile would be a good moved as maybe the excution plans would change with faster processing.

Though i'm happy to...

thank you both for your advise on this

Scott

I have solved the problem...

I had placed 2 'AS Royality' in the query.

Scott

sorry..the formatting has gone...not very readable

slightly long winded exercise but I;ve managed to work around using you code example.

SELECT @CHQPreReminder = COUNT(MM_MemberNo)

FROM tblMemberDetails

INNER JOIN tblSubscriptionDetails

ON tblMemberDetails.MM_MemberNo = tblSubscriptionDetails.SU_MemberNo

INNER JOIN tblPaymentData

ON tblMemberDetails.MM_MemberNo = tblPaymentData.PD_MemberNo

WHERE SU_RenewalWeek...

Thank you David.

Its because I'm running a letter schedule. We run letters at the same time for people who are pre-reminded of a renewal ie 2 weeks before their renewal...

Thanks everyone for your comments...

and a little extra precaution doesn't go amiss when deleting log files..

Ta

Scott

Just wanted to make sure nothing went wrong if I did detatch and delete the log. Thats now perfect.

Thanks all for your help

Scott

also it doesn't matter about the transaction log as its currently a test db. If I can delete it all the better

Thanks

Scott

I ran the Shrink File stored proc...

Named..SP_FORCE_SHRINK_ALL_LOGS

It hasn't worked...I still have an enormous file and can't seem to reduce it.

I'm running SQL 7.0 with 2000 Client Tools

Scott

Thanks Andy....as good as solving it 🙂

I read several MS related articles and worked them to the word and basically got more confused.

Not a problem..Your work around may well be...

Thanks once again for your help. Much appreciated.

Scott

Thanks Andy....

Just what I was looking for..

Cheers

Scott

Thanks again...

I'm on my way to the sites....

Scoitt