I think what Andrew is trying to say is that you should do the insert in multiple steps in SSIS.

Here is the order I would think you need to load...

The easiest way is to buy a product like RedGate SQLCompare or Apex SQLDiff.

You need to be careful with Arun's solution as SQL Server stores date and time, so if you used a function like GetDate() to set the Join Date you would...

Are you sure you have the same version of the Enterprise Library as was used in the project?

I agree with Steve that Service Broker is probably a way to do what you are looking at doing.

Your options are:

1. Replication - the Express instance can only be a subscriber. I'm not sure how this would work with Merge replication.

2. SSIS - Roll your...

I'm willing to provide you with some questions that might come up in an interview, but I won't give you the answers, you need to find them yourself.

What are the...

Well, I just successfully ran it on a DB in 200 compatibility mode. Try it in a dev environment first.

I believe column L in the spreadsheet is the # of pages in the index and the indexes that did not defragment have 26 or fewer pages. This likely...

If you are not familiar with triggers I recommend reading this article[/url]. Then write some code and post it here and we'll check it out.

Sounds like you have some IO Problems. I'd do a backup to another drive, even if you have to backup to a network share or attach a USB drive.

Whenever I see a query with OUTER JOIN's I my first question is do you really need OUTER JOIN's or are INNER JOIN's acceptable? IN your case specifically the...

GSquared (12/4/2009)

---

Jack Corbett (12/4/2009)

---

Unfortunately I agree with Grant here. It's never a good sign...

angela.morten (12/3/2009)

---

Thanks to all who replied, problem is resolved! In my description, I said C2 logging was not enabled. Turns out it was. As far as the permission problem...

I don't know how or if you could do it from a stored procedure, but you might want to look into PowerShell.