Ok. Thanks for the update. I do know that you can typically clean up the old replication stuff but it can be a bit persnickety if it gets in an...

From BOL:

Understanding DBCC Error Messages

After the DBCC CHECKDB command finishes, a message is written to the SQL Server error log. If the DBCC command successfully executes, the message indicates...

I'm pretty sure that executing the following will take care of your situation. However, having not been in it I can't say for sure. 😀

The following are steps 6 and...

You seem to be on the right track and merge replication would certainly cover what you are trying to do. You might also look at peer-to-peer transactional replication but you...

Just a quick update but I did do some testing and found that there is additional cost associated with the use of these as expected. Some of it is a...

I always have to...

Bruce W Cassidy (2/3/2009)

---

DavidB (2/3/2009)

---

Not a fan of triggers in any way.

With that being said though do you have any experience with instead of triggers and if so, what...

Jack Corbett (2/3/2009)

---

If your data is "marked" as deleted why do the developers need to issue a delete? Why can't they code the delete commands for those "objects" to...

Bruce W Cassidy (2/3/2009)

---

[font="Verdana"]How best to put this...

You might consider "database architecture" to be the parent of "database design". The architecture you choose will (to some degree) dictate how...

Thanks Jack! I will check out the discussion. I had just read the article prior to posting. Great article by the way.

Need is a big word that most people...

GilaMonster (2/3/2009)

---

ex__inferis (2/3/2009)

---

Hmm, I guess my comment didn't come across the way I hoped. It made so much more sense in my head. Lets leave it at "you're right, I'm...

I think he meant http://www.sqlservercentral.com/Forums/Topic642190-145-1.aspx#bm648464

Thanks for the laugh Grant... 🙂

NotManyPoints (2/3/2009)

---

I know what the things mean and DBA is more than the avatar it is stated as occupation.

It was a quizzical comment on the information about a person possibly...

Just a note, but just because AWE is enabled and you have 26 Gig allocated doesn't mean that you are covered completely from the memory needs of an instance. There...

Yes, Lynn is correct. No need for the trace flag.

Do you have any errors in the SQL Server Error Log or the Windows application log?