Us Jones' stick together. Or make mistakes together, not sure which.

I think the rant was a little emotional, and a little off track. It pointed out, however, that you ought...

Or right click the table in SSMS, script a select or insert to the query window. Then copy the fields to the insert and the select.

If you want point in time recovery, you need to have log backups. Set them up, maybe once an hour to start, and keep all log backups since the most...

What's quickly? What have you measured? What is the load on the db over that time? How many insert/update/deletes?

I was going to suggest the diff scenario. Apex Diff works well, as does Red Gate's Data compare (I work for Red Gate).

I don't think merge would work unless the...

One more note. Be sure that you keep a document of issues. As you can't do something, note what it is, what impact is has on your job or the...

You shouldn't be worried about the time for a restore if it's not your responsibility. It might be a concern, and that is something you raise to your manager, but...

Why do you want to update the ID field? Typically these are primary keys for each table, which means that they are not updateable.

If you have fields from two tables...

I'd add a third note that you need to get a consultant on site to help you understand this. Your questions indicate that you don't really understand what you are...

select * is resolved into the actual column names at compile time. If you have changed columns, then it might start to fail. This is why you never use SELECT...

thanks for the update. The other thing you can try is to script out replication and then re-run the scripts to set things up.

If I remember, you need a trace file of activity on the system and DTA will analyze it. It wasn't as good in 2000 as it is in 2005/2008. Tends...

there isn't necessarily any improvement from having the dbs in separate instances. You are now sharing memory, which is an issue on 32 bit systems. You have to set the...

Wow, sounds like you have a busy job ahead of you.

I'd look to do a few things. First, see if the clustered indexes make sense. They might all be created...

If you reindex, and then shrink without just truncating off the end, you may re-fragment the indexes.

I would recommend you shrink to a level that will let you work with...