Stef (3/5/2009)

---

Done a bit more research and it seems although Standard Version supports Partitioned Views it does not always consider it when creating an execution plan, hence why the first...

You could start by using relog.exe

http://blogs.msdn.com/granth/archive/2008/09/23/relogging-perfmon-binary-log-files-to-sql.aspx

Kendal Van Dyke (3/5/2009)

---

Replication honors transactional boundries, and the values for commitbatchsize and commitbatchthreshold dictate the number of transactions that are delivered to a subscriber.

How it works is NOT very...

There is a case in which you get the behavior you described.

1. If there are *no* EXPLICIT calls to BEGIN TRAN

2. AND you are using autocommit mode

3. AND...

Note that if it all happened in one transaction you will see one commit!

There are thresholds SEPARATED for "commands" and "transactions"

From BOL:

-CommitBatchSize commit_batch_size

Is the number of transactions to be...

Roy Ernest (3/5/2009)

---

Hey Noel,

Just wanted to update. The server was rebooted. The Log reader was stopped since the publisher was not there. I started it back on and everything is...

Glad you got it working!

Use sp_removedbreplication in cases where the distributor is not available or you just need to wipe all setting out.

SQL Dude (3/4/2009)

---

I've been running profiler, and reading to determine if my understanding is correct, hopefully someone can confirm or correct me.

Say a 3 different client application do the following...

Well there are tricks that to can follow to try an use a separate UMS but is not worth the effort in the majority of the cases...

Take a look at ALTER DATABASE on books online

Can you post sample data and DDL of your tables 😉

- Pages Scanned................................: 5

TOO Little 😉

It is actually expected to have different behaviors when changing compatibility levels!

It is all well documented HERE

glad you figure it out!