September 28, 2007 at 6:18 am
hi friends,
I have created Transaction Replication all is over
but my client is told know
can add one coloumn in SIFTY table add phoneno coloumn how can add the column plz explain me
Thx
September 28, 2007 at 9:54 am
To add a column to a table that is published for replication you can use the system stored procedure sp_repladdcolumn provided that the column can be NULL'able or has a default.
September 28, 2007 at 12:49 pm
We are all asumming you are using sql server 2000, right ?
* Noel
September 28, 2007 at 2:06 pm
yes i am using sql server 2000 only
September 28, 2007 at 3:03 pm
What if we are using SQL 2k5 I think same solution works
September 28, 2007 at 5:11 pm
In sql 2005 you dont need to use sp_Repladdcolumn. You can just do a regular ALTER TABLE and the table is modified at the subscriber too.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply