Thanks Gail. When I go over the publication ( there is only one), the type is SNAPSHOT. However, when I look at the PUBLICATION databases under PUBLICATION Properties, I get...

I'm positive that only Snapshot replication is what we are using. DBCC OPENTRAN returns:

Replicated Transaction Information:

Oldest distributed LSN ...

Thanks, Matt. I reconfigured that server option and it worked.

Best Regards,

Ray

I agree ... I guess I needed another set of eyes. We are going to be using all the base tables perhaps using a cursor in a stored proc. The...

Thanks to all of your responses. I've worked on mainframe DB2 as well and never encountered a situation where essentially the same index was propagated with a different name. I...

Adi Cohn (4/7/2009)

---

I once started working in a place and also noticed that there are few indexes that had the same structure but different names. I’ve made the mistake...

GilaMonster (4/7/2009)

---

Can you post the index definitions? If they are identical (same columns in the same order) they they're redundant indexes. It could be that they're not quite the same...

I suppose I found an answer but please feel free to comment:

"SQL Server fills the database files in a filegroup proportionally. This means if you have two data files, one...

Gift,

Thanks a lot for pointing that out. I kept worrying about the SQL 2000 configurations and left out the 2005 configuration. My bad.

All is well.

Thanks again and best...

Dave, Lynn and Darryl,

Thank you all for the insight. It is appreciated.

Dave,

Here is link to render the document in HTML:

http://74.125.95.132/search?q=cache:QqmCgQ5htecJ:download.microsoft.com/download/3/B/5/3B51A025-7522-4686-AA16-8AE2E536034D/Microsoft%2520High%2520Availability%2520Strategy%2520White%2520Paper.doc+microsoft+high+availability+overview&hl=en&ct=clnk&cd=2&gl=us

Regards.

Thanks for the response. I used to work at a place with a SAN in place. My current shop is small enough where that technology is not feasible. ...