Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-07-05 : 14:13:57
|
| Dear All,i heard somewhere that if we need to alter an article, we need to generate the snapshot again something like that.today i've configured transactional replication on my own system (distributor, publication, subscriber on same server).when ever i'm changing smallint datatype of a table to bigint on publisher, it is immiediatly altering at subscriber also. i'm just running the alter table alter column syntax.i'm using the transactional replication on sql server 2005 standard edition.please let me know that is it enough even on different servers? or we need to generate the snapshot also?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-05 : 23:17:47
|
| In sql2k5, transactional replication will replicate schema changes by default. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-06 : 10:32:16
|
| thank you very much rmiao, so there is no need to generate the snapshot again. am I correct?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-06 : 13:24:55
|
| That's correct. |
|
|
|
|
|
|
replication doubt