Maybe a explanation of how you would go about getting the experience needed to become one would be helpful. I would be interested to hear this as well. Also...

Amen to this post.. exactly what I have experienced. So much of what I have had to do did not always entail the database. I had to troubleshoot server,network and...

I thought that was my undertstanding as well. but looking at the dbcc ind command shows shared PAGEPID. I rechecked there are no FK's and no triggers to these ...

take a manual backup and see if it gives any more info than the package. Also what SP are you running?

Personally I would take option B from circumstances I have been through lately. Let me give you another scenario with Option A. Big company with big DBA team. At...

The command I was looking for earlier is:

sp_removedbreplication

You would not need this if you were dropping the subscription first. So in order to be able to setup a subscription on...

Ugghh had some documentation on this but cant find it. So basically there is a table that holds subscriber-distributor info that the repl monitor uses to populate the gui. It...

So what is the question? The row was not found at the subscriber like the error says. In another post I detail how to find the offending record then you...

I know exactly what you mean when moving to SQL 2005 there is less info on the error. Ah but there is a way to find it, and actually when...

yes and no. You will have to drop replication from the subscriber database otherwise it will have the settings thinking it is being replicated to. There are some stored procs...

from you saying this "and NO DATABASES appear in the list." My first guess would be a security issue. The account for your subscriber does not have any authority or...

To add to this here was my experience with TOE. So, I was in the middle of a consolidation project to consolidate a database in one city into a...

I wouldnt think it would have persisted over the reboot, maybe the reboot did not happen?

On that note, Why are you rebooting every night? Shouldn't need to if you do,...

Looking at your sp_who2 you will notice this SPid

62RUNNABLECDE\SVC-SQLFASDSQL1.CALSTARSINSERT139648426226614-Mar6:18:02SQLAgent - TSQL JobStep (Job 0x79F3492C9CE468409F08A2574351D7AA : Step 1)620

This job has been running since 15:00 the previous day and still shows running...

More than likely this has to be windows firewall related or dns related. You did say you were running windows 2008 server?