I don't know how to post a properly formatted block of code in the forum, so I just submitted my revised version as a new script, title = 'Generate insert...

Here is a more polished version of the script, enhancements: bracket column names to allow for spaces, add ability to tack on a prefix - this lets you generate a...

Did you ever complete your test? I'm curious to know the result. My guess is that the performance would be about the same. DRI (declarative referential integrity,...

Add:

where CONSTRAINT_TYPE = 'PRIMARY KEY'

to avoid scripting out the foreign keys.

Thanks a lot, this article is very helpful. But one problem I ran into was that the XML generated from my query exceeds the 4000 character limit on string...

OK, I just solved my issue. Like I said, I thought it had to be something stupid and it was. I forgot how the reporting executionlog table was...

I have almost the same exact problem.  Package didn't start failing until recently and as far as I know, not much has changed (server settings and security have not changed). ...

Thanks, I knew I had to be missing something obvious. 

Just to reiterate the value of defragging even in a RAID environment:

http://www.raxco.com/products/perfectdisk2k/whitepapers/pd_raid.pdf

From what I understand, its the opposite.  If your box is dedicated to SQL Server, there is no need to check "boost" and in fact, it can be detrimental (taking...

I just submitted a script that makes this easy.

Search for it or here it is:

'**********************************************************************

'  Author: Darren Gordon

'  Purpose:  To script all of your DTS packages out to text files. 

'  This...

I just submitted a script that makes this easy.

Search for it or here it is:

'**********************************************************************

'  Author: Darren Gordon

'  Purpose:  To script all of your DTS packages out to text files. 

'  This...

I just submitted a script that makes this easy.

Search for it or here it is:

'**********************************************************************

'  Author: Darren Gordon

'  Purpose:  To script all of your DTS packages out to text files. 

'  This...

I just submitted a script that makes this easy.

Search for it or here it is:

'**********************************************************************

'  Author: Darren Gordon

'  Purpose:  To script all of your DTS packages out to text files. 

'  This...

You shouldn't be able to, but you can...

Of course compiling C programs will drive a non-c programmer crazy.  They distribute their programs uncompiled just to piss everyone off.