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 |
|
keithc1
Yak Posting Veteran
88 Posts |
 Posted - 2004-07-01 : 15:24:20
|
| I have merge replication setup to "Continuously" update the subscriber, Is there a way I can undo this setting and schedule it or do I have to re-create the subscription again in order to schedule?Keithc MCSE MCSA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-01 : 16:28:26
|
| You can just change the schedule in SQL Server Agent jobs.Tara |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-07-01 : 16:29:33
|
| I have always had to re-create. When I wanted to alter a Table.If someone has a better way I would Shure like to hear about it.JimUsers <> Logic |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-01 : 16:34:45
|
| Yeah but he's not modifying the tables, just doesn't want it continuous. It's just a job schedule thing.Tara |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-07-01 : 16:39:13
|
| Sorry Jumped to the wrong conclusion.I found a way to add or drop fields. But if its in Replication you cannot change a field.JimUsers <> Logic |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-02 : 02:04:00
|
| Add a new columnUPDATE SET NewCol = OrigColRENAME OrigCol => UNUSEDRENAME NewCol => OrigColAssuming that this works [untested] it will play merry hell with the organsiation of the data in the pages, but might do as a stopgap until the next bigCREATE TEMPTABLE ... INSERT INTO TEMPTABLE ELSE * FROM MyTable DROP MyTablesp_RENAME TEMPTABLE, MyTableKristen |
|
|
|
|
|
|
Replication