Dropped the table on the subscriber and after a snapshot.. it did not create the table..

I'm out of ideas ... must be someone out there who...

I don't know what you mean by that.. which stored procedures?

I guess mean the ones that I see when I look at the propertieso f the article on the...

Tried this:

Exec dbo.sp_dropsubscription @publication='TowerDB to KOCSQL03', @article='COD' , @subscriber='KOCSQL03'

Exec dbo.sp_droparticle @publication='TowerDB to KOCSQL03', @article='COD',

@force_invalidate_snapshot=1

Exec dbo.sp_refreshsubscriptions 'TowerDB to KOCSQL03'

--

Exec dbo.sp_addsubscription @publication='TowerDB to KOCSQL03', @article='Tower.COD' , @subscriber='KOCSQL03'

Exec dbo.sp_addarticle...

Ended up being a probably with the antiquated SAN that was attached as a volume on the Server.

Backing up to the same Server now - but a locally attached...

Do you also have to stop all the replication agents if you are dropping or adding article to the subscription?

Yes.. permissions are fine.. I can backup most databases to this server.. it's the DBs over a GB that timeout with a Network error.. and it's...

I did run a snapshot. the REPL distribution job runs every 15 minutes as well

That worked. Thank you so much

Thank you for the reply.

select * from DBO.DATABASES against a sql server 2000 master DB only shows columns Databasename, Databaseuser, databasepassword and databaseserver..

I'll have to keep poking around :...

: ) Thank you for all your help!!!

i guess I don't understand what you mean.. are you talking about re-building the entire subscription? Can I script that out somehow? This...

when I run it against the publishing DB I get this :

Server: Msg 14100, Level 16, State 1, Procedure sp_addsubscription, Line 240

Specify all articles when subscribing to a publication...

Thanks. I looked and got my article ID and then checked mssubscriptions and my article is NOT defined in that table.

I tried to add it

sp_addsubscription @publication =...

Thank you so much for your help and please excuse my ignorance but.... the mssubscription table lists the articles by Article ID number, how do I get the...

i feel so dumb. worked like a charm. Thank you!