Many congratulations! Publication is a wonderful thing. Well done.

Unfortunately, I'm not much of a gamer any more and don't have this system, so my support will have to be strictly...

Jeff Moden (6/11/2010)

---

If you have a decent SAN, learn how to use the SAN "clone" or "snapshot" feature. We used it to "replace" a Tera-Byte copy of the production...

You can go to the advanced tab for the given step in the Agent job and tell it to retry a set number of times.

It's not rocket science. Just script the stuff you do manually. That's how we built it. Put it together over time, save the script, you'll be up & running in...

We set up an automated process that captures the security on the target system, restores the database, cleans out the old security, cleans up any sensitive data, then applies the...

You should take a look at sqlshare.com. They have quite a lot of videos that can teach you skills in SQL Server, including performance tuning.

I'd go with a TOP (1) and an ORDER BY on the value. You'll get exactly what you want.

Denny Cherry[/url] has a great little explanation of DTC.

That was strange. The original text was meant for a different response

I agree with Bhuvnesh, but I will add this: minimal access. Only give as much access as you absolutely have to, and no more.

Ouch. It's kind of shocking, the fundamental ignorance about how these things work that seems to be so wide spread.

Jeff Moden (6/10/2010)

---

Grant Fritchey (6/10/2010)

---

GilaMonster (6/10/2010)

---

Dan.Humphries (6/10/2010)

---

I do not activly seek such things but I am not sure you would be able to wipe the smile off my face with...

Real time monitoring & long term monitoring are different critters, as you're finding. We use Idera now. It can be tuned to capture more data than it's getting out of...

Again, not seeing everything, I suspect it's the two updates that are causing the issue. The INSERT & UPDATE is going to step on multiple pages or rows, in two...

I do this all the time on my local machines, laptop, workstation, etc., with no issues. I would not suggest you do this on a production system though. Installing &...