that makes sense..ill give it a shot

EDIT -> Worked Thanks..Strange that the Job created by the maintenance plan did not work if i tried to execute it itself.

thanks !

What about setting/changing the db compatability level from 90 to 80?

at the very least the table structure and data should come across?

ok thanks..i had a feeling that was the best way to go..i thought maybe there is a more elegant solution but thats fine

thanks !

agreed

smaller ranges will fix ur issue for now (in so much as you dont have to worry about running out of them.)

let us know how you go and if you...

Metallica - ...and justice for all

Gatecrasher - Gatecrasher Classics

Last Samurai Soundtrack

Sneaky Sound System - Sneaky Sound System

Filter - Title Of Record

this seems like a very weird problem to me..can you provide any other information about it.

is the issue occurring during the subscription process?

when are the servers disconnecting?

I believe that the system (because you have automatic ranges setup) will just apply a new range to the subscribers, (as to whatever you set in the automatic range identity...

No i haven't Greg,

however other posts on the net may prove more helpful, in my search i found that some people were having the issue because of the firewall and...

do you detach the subscriber databases?

here here to this editorial!

im not a SA buyer, but if MS was to guarantee some of the options in the editorial that would go a long way to making...

impressive..wouldnt google be challenging for the largest database ???

even though the linked table was a view ??

Ok My bad (once again)

its still the same problem except that the database was in Access2000 format not Xp or 2k3 format, once we upgraded the db to 2k2/2k3 level...

how are you trying to drop the SP?

try dropping it through QA,

a named subscription requires that you know the server name o the subscriber that will subscribe..

an anonymous subscription is when you dont know the name of the subscriber , eg...