Thanks for posting the solution back.

I felt that I had to post my version 😀

SELECT a.ShiftID

, a.TableID

, a.StationID

, a.EmployeeID

, a.CounterDateTimeStamp

, a.MusselCount

, a.CounterTimeSpan

,(SELECT TOP 1 b.MusselCount

...

Hmm..... Interesting.

Christopher Favero (8/27/2008)

---

yep I am testing it in a dev environment right now and so far it looks like the new table forces a new snapshot to be created and...

Ahhhh ... those times in which DELETES with WHERE clauses that were not highlighted ...

You will have to drop+recreate. It IS disk intensive ( especially if there are NC indexes in addition to the clustered)

To minimize impact you can run the rebuild using SORT_IN_TEMPDB...

me_balaji (8/25/2008)

---

I need to script to file all the statements necessary to re-create existing Publications, and to delete existing publications. I had this working in SQL 2000 using DMO,...

Is the snapshot agent scheduled to run periodically? IF so, are there any new articles added to the publication ? or Is anyone marking the subscription for reinitialization ?

Warning DROP INDEX for a PK does *not* work! you must DROP the CONSTRAINT!

dansell (8/22/2008)

---

I have approximately 30 tables that each have a near identical trigger. To help in error reporting and debugging, I'd like each trigger to output it's own name if...

Don't give people ddl_admin or db_owner rights ... Then you are safe 🙂

steve smith (8/22/2008)

---

noeld (8/21/2008)

---

Sorry for the bad news but from what I have seen in republishing architectures the solution is "peer-to-peer". Merge was advertised as the tool of choice once...

Totally agree with Michael above. You can built your custom logic on the MSrepl_* stored procedure scripts. Usually people use post_snapshot scripts to keep stuff easy to setup in case...

Sorry for the bad news but from what I have seen in republishing architectures the solution is "peer-to-peer". Merge was advertised as the tool of choice once but DDL replication...

Matt Slocum (8/18/2008)

---

noeld (8/15/2008)

---

The BCP files are created by the "SNAPSHOT" agent that runs on From that same machine. Please verify that the "DISTRIBUTION" agent is actually using the *same*...