I don't understand your server environments. Are your servers in different locations on different domains ? Can you use IP address (111.222.333.444) instead of server name ?

I lloked up cleantable and it says it is for reclaiming space after dropping a 'max' column, so I don't think that would help me. No jobs set to "append"....

matt.newman (6/23/2011)

---

I never thought I would be trying to perform and exorcism of ghosts as a DBA.

I have found a few more resources. Since the issue is recurring and...

GilaMonster (1/10/2014)

---

No, it's an unnecessary use. If the data is static during the day then there aren't going to be any X locks around to block the reports and so...

We have some semi-static reporting databases that run long queries. Some of them use nolock to avoid one report blocking another. In this case, the data was refreshed over night...

It might help to give specific info about your SQL version and relevant server OS version.

Yes, Table_B has 45,000 nulls in Email1, but that shouldn't be related to the 43 records. I can't see what is different about them. All 488 came from...

Ed, That gives me the 43 missing records.

"B" also gives me 445.

That makes sense. Looks like it's going to work, Thanks !

I tried something like this, and the temp table does contain the new MemID values, but get the error " Must declare the scalar variable "@MemberID"." during...

You can display all your views in SSMS "Object Explorer Detail" window, then highlight all the views you want to change. Right click and select "Script View As" -> "Drop...

Thanks, I was guessing it was something like that, but I have not found it yet. I assumed it would be on the target server where it runs, while pulling...

You can use Import/Export Wizard as Gail suggests, then when you finish setting everything, you can "SAVE" the wizard as an SSIS package that you can rerun each week.

There are...

Or maybe a SQL scheduled job that backs up the DB to a local drive, then step 2 runs a batch file to copy to DVD ??