Read committed is used when deleting

Some transaction used snapshot sometimes but none of them are running when testing this (because they will use tempDB for the versioning) otherwise it will...

I've look up to SP1 CU5 for fixes and nothing about tempDB or DELETE dml statements

Thank you for your post Lynn

However, my issue is not with the log file (this is handle separately), it is the tempDB mdf file size.

If I'm deleting half the data,...

Thks! It will help once I'll go take a look at those.

I believe I have an idea what's happening there now but still I will go check. For the pleasure...

Adding articles to a publication does generates some DDL events at the metadata level and there is no way around that.

I've read tons of documents and none ever tell that....

I'm testing a case when the initial replication is being requested. Articles are added once.

I believe I understand why you're asking that. As a DBA you have control and know...

Ok now I understand.

The issue occurs before the initial replication snapshot is being done. You can request to not run the snapshot when creating the replication which I did to...

Are you talking about the transaction snapshot isolation level?

Or the replication snapshot?

For the former it is the isolation level when an SP's running a transaction.

The latter I'm not aware of...

I've narrowed the issue.

It happen while the publisher's creating the articles to publish (before creating the initial database snapshot).

While this being done, if some code using snapshot isolation level is...

Yes it was the way I was told but I'm not the person who got access to that website (yet)

Still waiting for my keys, probably the holidays were for something in that delay.

Thanks for answering.

I've googled for Technet licenses information and found nothing so far.

I prefer knowing the details before testing but at last resort, yes I would need to try it...

I've received a notification from a program we were participating (we're not into an NDA however but for security reason I won't disclose more info on how I get that...

Yes it is transactional replication.

I believe we are bound with this solution. Any ideas for managing identities then?

My mistake

Yes it is replication not log shipping.

We have a database currently in use.

We have setup replication through RMO to support a secondary server (a warm backup server).

RMO is used...