all groups > sql server replication > october 2006 >
You're in the

sql server replication

group:

Warning with sp_repladdcolumn



Warning with sp_repladdcolumn Alexander Wolff
10/13/2006 10:11:02 AM
sql server replication: When adding a column to a table involved in merge replication through stored
procedure sp_repladdcolumn:

sp_repladdcolumn @source_object = ' InspectorForaneó, @column = ' password',
@typetext = ' varchar(20) null'

I received the following warning:

Cannot add rows to sysdepends for the current stored procedure because it
depends on the missing object 'sp_sel_2FEE03EE3F16401386A1A3AA13AC4F73_pal'.
The stored procedure will still be created."

The Stored procedure that to sqlserver says that it does not find..Is
present.
The replication seems to be working well, but anyway I would like to know
the reason for the warning.

somebody has some idea of this?

thanks in advance,
Alexander.
Re: Warning with sp_repladdcolumn Paul Ibison
10/13/2006 8:00:43 PM
Alexander - does the object 'sp_sel_2FEE03EE3F16401386A1A3AA13AC4F73_pal'
exist? If so, I think this is just a problem of ordering of creation and
nothing to be concerned about.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

AddThis Social Bookmark Button