It sounds as though "DateOfInterest" is not a datetime field.  If not, then perhaps SQL is looking at them as:

10012004 and 09302005   so the first number is actually bigger than...

Use SP_WHO2 to identify the connections. If someone opened the DB via Enterprise Manager (including you), that can often leave an open connection.

Why not just schedule it to run at those times and be done with it ??

How frequently do you need to refresh the data ??

I use transactional & snapshot replication to get subsets of production databases to other databases. Then users can query the subsets...

What does it show under "Next Run Date"  ??

Sometimes I've had the job enabled, but the schedule was not enabled. They both must be enabled.

Perhaps there's an "end date" in...

If you backup the database on the "old" server, then do a restore on the "new" server, it will create the database as part of the restore.  You might want...

I had to do something similar a while ago.  I think I did something along the lines of:

- Script out the steps to delete the publication and save it. 

-...

You can use "snapshot" replication instead of "transactional" replication for tables that don't have a primary key.  This will replace the table each time instead of just sending changes, so...

You want to set up replication on other servers (B & C) that's the same as what you have now (server A)?

If you just want to copy the publication, you can...

What about making objects DBO owner to start with, such as tables and stored procs ?

Does a user have to be a System Administrator in order for their...

Does a user have to be a System Administrator in order for their objects to automatically be DBO owner ?

Not sure, but how about using sp_droppullsubscription first to get rid of the orphan subscription, then maybe you can drop the publication ? (Either through EM or manually via...

I go into EM, make all the changes, choose "Save change script" to capture all the commands, then exit without saving the actual changes.

Or sometimes I do save the actual...

The job itself is enabled, but how about the schedule entry ? Right click the job >> Properties >> Schedules >> Edit ......... Is the enabled...

I did this recently .......

I just used Enterprise Manager to generate a SQL script for all SPs, but put them all to one file big on your C drive, then...