you may want to change "db_owner" to "db_ddladmin" 😉

In addition you are using SQL 2000 "compatibility" views you are posting on a SQL 2005 forum!

DMV are supposed to be used instead.

Use google there are a ton of scripts to do that. Don't try to discover the wheel.

Index missing are "HINTS" based on usage at a particular time period they are not actual necessary indexes that you need. Be really careful with that!

I have found that the best solution for this is to use persisted calculated columns!

Just don't specify the identity column in your insert statement.

Nils Andersson (1/27/2009)

---

Hello,

Can this be done.

I want to return distinct name if complete is true on all rows

ID NAME ...

Distribution database is like any other DB. If you insert a lot of commands it has to grow.

File size management is up to you!

Clearly FK violations on the "SUBSCRIBER" could be impacted but as already said above this has nothing to do with replication if the problem is a on the "PUBLISHER"

I liked your article ( a lot ) and it seems that you put a lot of effort into it.

My view of running totals is simple. It is a CLIENT-SIDE...

Locking could be an issue if there is a lot of contention and temptable version "could" be better and on the other hand the subquery version could skip some extra...

See my post in the other thread!

Please, do not double post.

Swiss-Al (1/21/2009)

---

(This is a partial re-post of thread "Log Reader Agent Errors MSSQL_REPL20011 / MSSQL_REPL22037")

I seem to be observing a parameter mix-up in a transactional replication. The parameter "ReadBatchSize" which...

IF you have enterprise edition you can select "database snapshot" for snapshot type It WONT lock the tables extensively like native mode does. If you don't have Enterprise Edition...

Can you post the DDL of you Indexed View and the one of the underlying table ?