Thanks Roy.

The following procedure will stop the replication jobs for a subscriber. You have to...

Yeah, I have a report that looks at last day of a database backup to avoid things like that. Hopefully you won't have to use the backup. Regardless, have them...

Just a thought too, but while the DBCC continues you might want to start looking at backups and ensuring that you have one available and ready to go if the...

You should be able to disable them via the jobs. Can you explain what problem you had doing it that way?

Thanks.

Check out THIS LINK and see if it helps.

Hey Paul,

I haven't personally made the move that you are discussing but have moved into management and then back out of because I liked the technical. The one thing...

I had used Audit DB from Lumigent a few years ago and it was a nice consolidated application at the time.

Found that the script only works if the fileid's are actually sequential. I have modified this so it works with the following code.

IF EXISTS

(SELECT name FROM sys.sysobjects WHERE...

Noeld's suggestion is appropriate here. Use a cursor. Refer to BOL for examples. HTH

Florian Reischl (5/6/2009)

---

......

You might want to try updating the mdac components. You can download the latest HERE.

balbirsinghsodhi (5/5/2009)

---

Yes, Transac is a view based on two partitioned tables archive and live. It's really weird that sometime it is working slow and sometime works just fine. Long time...

Nope, should be just one unless you execute one specifically 🙂 . The checkpoint should occur pretty quickly as noted in the one perfmon counter earlier discussed. If you run...

Too hard to tell. How many indexes are there is the key...

Standard question / answer but have you rebuilt all indexes associated with this procedure? If not then that should be the first step. The index rebuild will take care of...