Could you or someone have installed this database on one of the individual instances and not the virtual?

Hey, I can't cause trouble every day.

Please start your own thread for a question, post table DDL and query code.

This almost sounds like homework or an interview question.

You should write some code, make an attempt, and if you don't understand what works or doesn't, we'll help. But we don't...

I'm not sure what you're doing here, but this isn't the appropriate forum. I am moving to the T-SQL forum, but if you are using SSIS, then please state that...

You might want to call MS support and work through this, checking to see if you might have hardware issues.

Were you asked to create a presentation for how to do this? We don't do your work for you. There are some good links above to help you learn how...

Moved to T-SQL

You should trace and see how the application is inserting data. There might be something else.

Are there also instead of triggers on the table?

You need to provide some...

Lynn, that's down the road, thanks for the recommendation.

And remind me to drive when we get to go out for a beer.

Depending on how you implement search, it might work well. I wouldn't be afraid of EV, I'd think about or look for good search code.

Maybe you should mock up a...

What do you mean the data is XML? How are you exporting it?

Two ways.

1. script out everything in db A, including permissions and run it in B.

2. Restore B from a backup of A, whack the data you need removed.

ApexSQL has a log tool that will read the 2005 transaction log. You can purchase this, but I'm not sure it shows who performed the transaction. The transaction log isn't...

IP?

It's enabled for database mail, so I don't think there's anything wrong with turning it on.