Home > Archive > SQL Anywhere database replication > September 2005 > Procedure sp_add_article not found









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Procedure sp_add_article not found
Alex Hidalgo

2005-09-05, 11:28 am

Im coneccting to a database as DBA, and I need to create a new article for a
Publication.
When I launch the procedure sp_add_article 'Pub1', 'article1' I get a
"procedure not found message". I putted DBA into the DBO group but still
failed.
How can I do it?
I will launch the sentence as a script embedded in an PowerBuilder
application?


Thanks in advance,

Alex Hidalgo


Dmitri

2005-09-05, 11:28 am

Alex Hidalgo wrote:

> Im coneccting to a database as DBA, and I need to create a new article for a
> Publication.
> When I launch the procedure sp_add_article 'Pub1', 'article1' I get a
> "procedure not found message". I putted DBA into the DBO group but still
> failed.
> How can I do it?


First, as you should have guessed, sp_add_article is an ASE procedure.
Second, ASA has ALTER PUBLICATION for that purpose.

Dmitri.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com