Thanks guys. I got it straight now.

Christine

Thanks for responding Steve. The data does grow but very little (a little less than 1%), and yes I have both the dB file and the log file set...

What is a runtime in the app? Forgive my ignorance on the programming side of things, that is exactly why I'm out here trying to learn more about how...

The database is marked suspect, yet the status in sysdatabases is 'normal' = 8. I have tried to over write the log file. Ah, the light bulb goes...

Thanks guys. We just stopped replication and drop the distribution dB (warning*** we were sure we have our data) and started it up again and rebuilt the distibution dB...

Andy, I am right there with you. I think this actually will solve the problem. I am not terribly concerned about lost data. I think we are...

Thank you so much Andy for your time. At this point I do not have anything to lose so I will probably give the manual thing a go. ...

Yes, have done that and it appears that the MStransactions and MScommands tables that are incredibly huge. Does that shed any light? We feel like the data in...

Did that although it suggested that it cleaned up a few transaction (not a significant # that would make the dB "weigh" in at a whopping 9GB. I...

Can the sp_reattach be run (against distribution dB) while writes to the (distribution)dB are happening?

Chris

Edited by - Christine Austin on 08/20/2002 11:04:10 AM

Is the clean up job a system run process or custom? (I told you I was new to replication) In the meantime I will...

Yes that's what I thought, but...Well it appears that after very large transactions posted the dB, it has not "cleaned" itself. I would like to know if there is...

Yes, I understand and agree, I was just hoping there was documentation or benchmarks for SQL 7.0. I have already done my own testing and wanted further documentation to...

Also, be sure the account you are starting your service has Admin rights.

Question: Have you loaded your mail client to the server yet? And what version of SQL...

You're right. I want my developers to be able to develop sprocs that may select, [insert, update, create temp tables]but altering system & dbo tables is off limits. ...