Might sound lame, but check to see if there's some System DSN created (in Administrator Tools, ODBC)

Sounds like there might be a "prd" in that that's pointing to your "local"...

For anyone wondering about this thread:

The steps taken from the prior attempt were the proper steps. It would appear that the "network blip" that occurred while I was doing...

After I calmed down (stopped freaking out) a quick search showed me all the objects that had this "bad column - FraudMemo" and this time stopped the Log Reader Agent...

lazarusek (6/3/2010)

---

Hi again,

He got holidays here, so apologize for a delay. I found the workaround on my blog that I created a long time ago. Hope it will help...

Okay, last night I tried the ALTER DB SET SINGLE USER method and it ended up not being able to repair everything (I accidentally overwrote the error output so i...

I'm sure this is probably a stupid question...but is there a preferred method to taking a subscriber offline?

No we don't have a SAN and we have our Tech Services department perform the defrag. This has only ever happened once and it took an entire weekend to...

Thanks for the responses! So if I do the repair_rebuild option, since this is a db at the subscriber the subscription and repl_commands are going bomb while they attempt...

The CHECKDB is fine on the Publisher database. No errors.

I am not confident on how to drop an article from replication WITHOUT regenerating the entire snapshot for the entire...

Although your question has already been well answered, it might be helpful for you to know that using SHRINKFILE frequently with a database that will grow beyond limits over and...

I believe you can accomplish this by setting up an ODBC connection on the server itself (Administrator Tools > Data Sources (ODBC), create a System DSN, Choose your driver and...

Hyperbac intercepts the data stream while it's backing up, correct? It's done on the fly which results in considerable time being saved during a back, the same thing applies...

Lynn, I am not overly familiar with this type of compression, can you recommend some good links/books?

I'd like to hear your suggestion anyway Lynn!

There are probably many (MANY) answers to this one...my thoughts are based upon a lot of assumptions and may or may not be applicable to your scenario...

Are you using backup...