there are a number of posts by Jeff Moden to do this via BCP; he refer's to the issue as "ragged right";

here's one example he posted to address the issue...it's...

consumable data for the next poster:

With [MY DATE](ITEM_NAME , CODE , [DATE] , OB_QTY , RECD_QTY , ISSUE_QTY, BALANCE_QTY)

AS

(

SELECT '5 PR CABLE','05','01/04/10','25','0','0','25' UNION ALL

SELECT '5 PR CABLE','05','02/04/10','0','2','0','2' UNION ALL

SELECT '5...

you might need to explicitly define the columns:

INSERT INTO tblHistorySource(Column1,ColumnList,CreationDate)

select Column1,ColumnList, getdate()

from DELETED --the old values...new values are ijnt eht able if you need to compare them.

also, completely remove this...

wouldn't the new to SQL2008 Change Data Capture do what you need? plenty of articles on that, when i tested it it worked really nice.

The scripts for an index, like the scripts for a table, don't actually get saved/stored the way a procedure or function's body does;

it goes straight into the metadata, so you...

details....

I've got a nice example where a replace all the Last Names of a table with one of the standard HTML colors;

I use variations of this to munge data so...

just to confirm, from inside a trigger, you cannot always get the whole SQL statement; you can use DBCC inputbuffer, but that returns only the first 255 chars; a lot...

Colleen nailed it, I'll just try to explain:

There are several threads here on SSC on Linked Sserver performance;one thread which stated that openquery against a linked server was faster for...

As an FYI, i bought a recent Win7 HP laptop with 19" wide screen and full keyboard.

While i love the OS and layout, I get more Blue Screens Of Death...

well... start with the basics....if you want real help, you'll have to give real details.show us the exact code you are using.

comment out 99% fo the code , run the...

the section you pasted looks like it came from a .net config file. i think you're having trouble directly related to that....are you doing ASP classic or ASP.NET?

the connection string...

Mr Magoo I'd love to hear the back story on this...might be very educational for us....

what happened that made you start thinking something was flooding the server...after looking at the...

i realize this is probably a smippet, and not the whole page, but bear with me.

I do not see the connectionstring being assigned to the connection object, nor do i...

Khades (2/16/2011)

---

Oh Thanks, awesome!

What about question 2 though? Will having Child procs for the code to run parallel to each other improve performance?

And can 1 proc run parallel to itself...