Thanks for posting the CREATE TABLE for two tables. Can you please add the third? Because "the usual .net membership users table" may be obvious to you, but it isn't...

Ouch, that sounds painful.

If you have differential backups, than at least one full backup must have been made - otherwise SQL Server will not allow you to make a differential...

Unfortunately, I have absolutely no clue where @@REMSERVER takes its name from. I am sorry to not be of more help. 🙁

In addition to George's reply:

1. You can only use this technique to restore to a point in the past if you were already making both full backups and log backups,...

Ah, that explains my confusion. Good.

I do still have some more questions, though:

1. In the CREATE TABLE for the EmisEvent table, I see only a clustered index. Are there no...

No CASE expression needed.

To find the BF rows that also have a BE, use a SELECT with BF in the WHERE clause, and an EXISTS subquery to check of there's...

Now I am confused.

In your original post you included a query for the insert that showed the new rows as coming from a simple select on a single table: dbo.EmisEventExtraction....

First, change the settings for tempdb. The settings you use are miniscule. Every time the server restarts it will drop tempdb and recreate it using those settings; and then it...

Thanks for confirming my suspicion.

I'm afraid I cannot help with your questions on the import & export wizard and identity, as I never used the former, and try to avoid...

Just a quick note to tell you that I did see the message. But I won't be able to look at it right now. Car broke down when I wanted...

If you never have more than one call per call_date, then yes it is a candidate key. Otherwise...

Hi Priya,

You are posting your question on a topic that is one and a half years old. Since the question is only very loosely related, that can be confusing. It...

If you want to partition by year, then you will first have to make sure that the date column is the leading column in the clustered index. You will probably...

Check whether there is an IDENTITY property on the insert target on one of the servers, that is not present on the other server.

When not supplying a column list for...

Just learn to enjoy the bumpy ride, and try to keep confident that eventually you will...