Thanks for your help David,

Here's our set-up:

OS - Windows 2000 Server SP2

DBMS - SQL 2000 w/ SP2

Mail Client - Outlook 2000 9.0.0.2711

Mail Service - Exchange 2000 w/SP2

I have followed the...

Thanks Eva, yes beleive me I have combed all the forum topics looking for answers. I have tried what has been recommended but I am still getting the same...

I am experiencing similar problems. Have all the correct SP's in place, set up the accounts according to spec. and still I get some error message ('18025 xp_test_mapi_profiile...

Thanks David. Actually, I haven't noticed any unusual activity. Its the wierdest thing.

Thanks,

Christine

I have a very similar dilemma. I have several sites set up to 'push' data to the subscriber. The sites are currently set up as the distributor and...

Thanks gentlemen, I think given my circumstances I will check the indexes first. Occassional I will get error 1204 and I am not really sure what's causing it? ...

Thanks Andy, actually we have run sp_updatestats on all dB's on both the publishers and the subcriber. Where would I check the batch size that's currently running? (I...

Thanks guys,

The information you offered is greatly appreciated. As we move forward with our design discussion I will be sure to research more on the options we discussed and...

Thanks Andy, but I guess what I really want to know (and I realize this is a professional opinion, just hoping someone has been confronted with this design question)

When dealing...

The upgrade went well not without a hitch though. So for other DBA's who may need to upgrade a MS SQL 7.0 database to a SQL 2000 dB in...

One last thing the publishers are running NT 4.0. Will this change anything?

Christine

So far testing is going okay. But now we have a 7.0 site replicating in to SQL 2000 and we're getting an ODBC error message. Do you know...

Do the users you speak of really need EM on their desktops? Generally speaking, it is a tool mostly for administrators wheras the client tools are geared to allow...

Thanks for all the responses.

Antares686, I have seen plenty of memory leaks in SQL 7.0, when a simple DBCC shrinkdb is run. From what I've read this...

Thanks Steve and everyone else who assisted me. This was great!

One question though Steve, wouldn't I get a sharing violation error if I didn't stop SQl server first?

Christine