Added a column to one table with sp_repladdcolumn in publisher/distributor.
This warning comes from every publication this table belongs to:
Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp_sel_C245F32C38A611D525494BFC6FD140A7_pal'.
The stored procedure will still be created.
In use: Merge replication and static filtered publications referencing this
table.
Is it safe to continue and trust that everything works after this? What is
this _pal ending sp? What happens if it does not exist and what should we do
next?
Thanks - M
Its fine as long as this proc is present in all subscribers.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Untamo" <Untamo@.discussions.microsoft.com> wrote in message
news:0BC7CA5F-872E-4AB9-B1EB-F0ADCDD435B6@.microsoft.com...
> Added a column to one table with sp_repladdcolumn in
publisher/distributor.
> This warning comes from every publication this table belongs to:
> Cannot add rows to sysdepends for the current stored procedure because it
> depends on the missing object
'sp_sel_C245F32C38A611D525494BFC6FD140A7_pal'.
> The stored procedure will still be created.
> In use: Merge replication and static filtered publications referencing
this
> table.
> Is it safe to continue and trust that everything works after this? What is
> this _pal ending sp? What happens if it does not exist and what should we
do
> next?
> Thanks - M
Saturday, February 25, 2012
missing object warning when adding column to table with sp_repladd
Labels:
adding,
belongs,
column,
database,
distributor,
microsoft,
missing,
mysql,
object,
oracle,
publication,
publisher,
server,
sp_repladd,
sp_repladdcolumn,
sql,
table,
tocannot,
warning
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment