reported as SPAM

Hm,
I don't  believe  you would be happy with 16 MB TempDB
Maybe you can  calculate the size of the TempDB with this script:

SELECT
 ...

Hi,
have you ever tried to skip the error in the replication monitor?
If you are on the server with an "sa" account, you should start the replication monitor and...

Hi,
I think, it is possible to add an article, without creating a new snappshot with all alrticle. If you lock for these parameters, it is possible, to create a ...

Hi,
if you just want to replicate the newer data, you can create and work with this kind of "filter":
https://msdn.microsoft.com/en-us/library/ms151775.aspx
If you have synchronized your data, you can...

Hi,

are you using a singel instance, or a part of a cluster?

Andreas

Hi,

had you tried to count the IO, when the query runs:

https://msdn.microsoft.com/en-us/library/ms184361.aspx

And what about the execution plan, can you see something interesting inside?

Regards,

Andreas

Hi,

could you check, if your article were stored on the distributor?

Every article should stored in the snapshot-folder.

And can you execute this query on the publication-database:

"sp_helppublication"

And, have you checked, when the...

Hi,

it is not nessesary to break replication, only to add a new articel.

Please watch this link: http://saveadba.blogspot.de/2011/08/adding-new-article-without-generating.html

We use this once a week.

Regards,

Andreas

Hi,

yes, I have a test environment.

Kind regards,

Andreas

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 database....