I got replication to run.

It added the missing article.

There is no data in any of the tables.

What could I be missing?

When I view the Snapshot Agent Last Action it states that a snapshot was not generated because no subscriptions needed initialization.

The subscriber tables are all empty.

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 [Transaction Name] = N’DROPOBJ';

...

Thanks.

I saw the first article but I did not see where you identify the Login,

How do you read the transaction log?

The second Example may be easier.

Thanks again. 🙂

A Developer informed me that there was Data in the tables and that they were being replicated.

Then he tells me the tables are empty.

I created a snapshot and that step...

I just inherited this Server and a lot of other things. It has not fully been transferred over to me.

I have checked for fragmentation but I have to wait for...

Markus (6/30/2015)

---

CPU was at 100% and memory was at 97% before you started replication... and you thought that turning on Replication wouldn't have bad effects? Yikes. You have...

Hi,

It is push transactional replication.

There is only one instance of replication.

Thanks.

CPU was at 100% and memory

was at 97% before Replication was turned on.

The users was the data refreshed within seconds.:w00t:

So the Server needs beefed up.

Thanks for your advice.

Have a good...

I turned off the SQL Agent and Reader Agent.

I turned off Synchronization.

After that I disabled the jobs.

I basically shut everything down. :blush:

Ozzmodiar (6/29/2015)

---

If it's temporary; you can just disable the associated SQL agent jobs. Then adjust the schedule so they run at a time when the server is not under...

I'm enjoying talking to myself.:hehe:

The blocking issues are much better.

Would I do something like this and the other 2 Tables?

select * From distribution..MSsubscriptions

--- based on the above values, run below...

I take it I'm on the No Fly List. 🙂

How do I turn this off?

update MSsubscriptions

set status = @INACTIVE

where agent_id in (

select derivedInfo.agent_id

from (

-- Here we are retrieving the agent id, publisher database id,...

This command is executing.

It seems to be related to replication.

How do I prevent this command from executing? It is blocking another process.

How do I stop replication entirely?

Thanks.