I execute this and I get the following:

update #tmpTotals set StateCount = ISNULL(Select Sum(DayCount,0) from #tmpTotals t where Loss_state = #tmpTotals.Loss_State )

Msg 156, Level 15, State 1, Line 40

Incorrect syntax...

Thanks Gail! 🙂

Thanks Phil. 🙂

I keep trying to create a snapshot but I got error that various objects did not exist.

So...

Jacob Wilkins (7/1/2015)

---

Welsh Corgi (6/30/2015)

---

I do not see where this code is reading a Transaction Log?

SELECT [Transaction Id], [Begin Time], SUSER_SNAME ([Transaction SID]) AS [User]

FROM fn_dblog (NULL, NULL)

WHERE...

Replication is working. 😎

Thank you to everyone for your positive feedback.:-)

I believe this will turn the Agent back on?

[/

if exists (select 1 from distribution..MSsubscriptions where status = 0)

begin

UPDATE distribution..MSsubscriptions

SET STATUS = 2

WHERE publisher_id = '--publisher_id -- will be integer --'...

I clicked on Publisher to Distributor and it list 2 seconds.

Distributer to Subscriber is Pending.

Total latency is Pending as well.

What do I need to turn on?

andreas.kreuzberg (7/1/2015)

---

Hi,

are you sure, that you, ore the used service account, had all rights. We have a special user called SQLREPL, who had db_owner rights on the publisher, and subscriber...

I get an error that the Replication Monitor could not reinitialize one or more subscriptions that support automatic initialization.

The current operation was aborted because it would deactivate an article in...

jsterrett (7/1/2015)

---

The snapshot is just going to BCP data into files on the path specified to the distributer. Can you verify if the snapshot has been deployed to the subscribers?...

Justin Manning SA (7/1/2015)

---

Welsh Corgi (7/1/2015)

---

I reinitialized and created a new snapshot.

I got messages that the Data was being bulked copied.

There is no data in any of the tables....

I go into the Distributer To Subscriber History and I get Skipping File 'Trades' it has already been delivered for a previous article or a previously interrupted snapshot.

I get this...

I reinitialized and created a new snapshot.

I got messages that the Data was being bulked copied.

There is no data in any of the tables. :sick:

jsterrett (7/1/2015)

---

I would look at this from another angle. What is blocked? What is the lead blocker? Where is the blocking occurring? For example, its common to see blocking...