Well I tried backing up the database manually and that didn't change the fact that when I try to restore it on another server the original file name is completely...

Yes I am backing up with a maintenance plan.

So there lies the problem correct?

Cool.

I will go for it being cautious optimistic....

Very interesting as I see this scenario often around the web.

Wonder what I'm missing.

1). Server Name definitely was changed @@servername returns null

2). When looking to drop and...

Yes the server is its own distributor.

Both queries returned nothing.

When I query MSarticles I do results.

When I run select @@servername I get a null returned.

I thought that...

When I query the syssubscriptions table there are no rows returned.

I would think that I would get some rows returned

use distribution

select * from syssubscriptions

When I query the syssubscriptions table there are no rows returned.

I would think that I would get some rows returned

use distribution

select * from syssubscriptions

I've seen this before where it just says under the command column KILLED/ROLLBACK and can run for over a day. WaitType = OLEDB

The only way I have removed this before...

I will give that a try.

Should I wait till the cancelled query is finished or just restart the service?

I cancelled the query in QA and that is just sitting.

The...

When running sp_droppublication and it just sits I do not see any blocking spid.

Looked in the activity monitor.

Checked the sys.dm_tran_locks

Checked the sys.dm_os_waiting_tasks....

Any other suggestions.

I have stopped all...

Thank you for that suggestion.

I will take a look and follow up.

It is still running from last night aprox about 15 hours....

Any suggestions....

Can I look to remove more then one subscription at once in another query window? Or wait for the first drop subscription to complete

What happened was that it was a stored procedure that was trying to update a mirrored database.

Therefore I could not replicate that article over. Once I removed that article...

Yes this is a two machine configuration. As of right now I do not have a third machine to be the distributor. Machine A is steadily using 77% of the...