Sometime that XProc is manually renamed or dropped by DBAs due to security issues. You may want to confirm that the proc still exists on the server.

-Dan

We are doing something similar, but not because of the primary keys though...Anyway, what we did was create triggers on the base tables for insert/update/delete that will insert a record...

From the MS Website:

Status Meaning

Background: SPID is performing a background task.

Sleeping: SPID is not currently executing. This usually indicates that the SPID is awaiting a command from the application....

I think you're outta luck. There may be a long shot...if you had Full Recovery Model turned ON, and had never backed up the transaction log, and all data had...

quote:

---

Two users could be setting the flag to locked at the same time, they would both read the flag as being zeroed,...

You can use the sp_resetstatus system proc. That will try to force the database online/healthy. You have to stop/start the server to take affect, which may be a...

The database can be detached while the server is operational, but not the database. All users must be out of the database before the database can be detached. ...

I'm not sure if having the empty tables will help...I created empty versions of the tables on my machine and the query works fine. On our server, the address...

We had some similar problems related to an Active Directory upgrade...After upgrading to AD we left a couple of NT PDC/BDC's on the network to handle authentication of old NT...

This KB article from MS might be what you need: http://support.microsoft.com/default.aspx?scid=kb;en-us;274098

I ran into the same problem. The key is to set up the Linked server before setting up replication...but...

Thanks for the script...maybe in the next version of SQL Server it will be just another tab in the Maint. Plan...

-Dan

Just had a brainstorm...what about this?

1) Create subscription database at subscriber

2) Backup publisher DB

3) Load publisher DB into subscriber

4) Create Pull subsription at subscriber and start syncing

5) Perform differential backup...

I've recently converted a bunch of procs from temp tables to table vars, and have seen performance improvements of up to 10 times. You can create a primary key...

Just to answer the questions posed...

I'm not compressing the snapshot. I'm using concurrent snapshot generation because I can't lock the production DB during business hours. The BCP files are...

My only thought is that the server is picking the wrong execution plan due to the fact that the tables are being created AND populated in the same proc. ...