These are quiet large databases, terabytes of data. So recreating it by scripting out the objects and then loading the data using SSIS or TSQL can be extremely time consuming...

Is it a local windows account or domain account?

I've dealt with issues where the account was unable to resolve the domain and the job hangs or fails.

Does the job...

Beautiful 🙂

I can actually see it getting fired off!

One problem though - it was only inserting the last record of the batch. So I did some googling, and I...

Craig Farrell (10/27/2010)

---

That looks right to me... I assume that's a simplified trigger for our benefit.

Some things can ignore triggers, like Bulk Insert has the ability to turn it...

Hi folks,

So I was able to successfully produce the file exactly how I wanted, but except for one minor (ironically, has been a big headache) problem. I'm unable to...

John, you made this look so easy! 🙂

This is exactly what I was looking for. I'm gonna go ahead and apply this solution and will share my results. Thanks again!

So, no one has anything to add with respect to this dilemma we're facing?

I must say, I am disappointed in moving to an enterprise platform, that's supposed to be robust...

Steve Jones - Editor (4/8/2008)

---

I haven't seen one. There are quite a few SQL Server XML functions and you might be able to read through the tables (sys.tables, etc.) and...

I gave this a try and it worked like a charm. Much better performance wise. Thanks Peter and everyone else for the effort!