Thank you. I really do appreciate it. Tomorrow I'll try to go through the same steps with a...

GilaMonster (3/31/2010)

---

You can also disable distribution, right click the replication folder, configure distribution. I think the options are there to disable. If not I'll go research. I don't actually have...

OK. Figured out the DBO error, changed the ownership of the database and deleted replication publication.

Do I need to delete all the agent jobs related to replication manually?

Run query on...

On a new server, after adding replication, could not stop the agent job, since "the...

Gail,

On a production server, got a message: "There are no publications to which you can subscribe, either because this server has no publications or because you do not have sufficient...

SQL 2005 Express 32 bit currently on production.

SQL 2008 Standard x64 on a new "replacement" production server, where I'm trying to migrate the databases from 2005 express. Only #5 is...

Wow, and I'm blaming all of it on the power failure...

I may not have communicated it correctly, #2 is setup by manufacturer's DB creation utility, so #5 idealy should...

Gail, there are no objects on either new or production servers under "replication" besides empty folders "Local Subscriprions" (on both) and "Local Publications" (only on a new 2008 server).

Gail,

After using Google to find the way to query sys.databases (you see, I'm just learning to steer this ship), here is what I see:

1.NOTHING

2. ACTIVE_TRANSACTION

3. NOTHING

4. NOTHING

5. REPLICATION

6. NOTHING

7. NOTHING

8....

ALZDBA,

1. The DB I have here is a copy of a live DB on a production box, which had been a subject to a power failure and data corruption on...

Sorry, Gail, I didn't mean to be gender specific. Here in AL a good half of the ladies would get offended: "who exactly are you calling a lady?" LOL.

Here is...