Is there a definite fix for this ?! I am running 2005 64bit on SP2

I have tried everything and it looks as though I can no longer debug -...

Many thanks

The area I was looking for was refirred to as Multiplexing: Using Middleware, Transaction Servers, and Multitiered Architecture

in bold it states "Use of such multiplexing or pooling hardware...

One nice thing you can do well using all of these EM features is have profiler running in the background. That way you can view all the SQL commands that...

Completely agree it serves no real purpose, I am still looking forward to using the middle join we were taught in yesterday’s class

I have tried to write something similar, however the reason for writing our proc was to search for those statements that change the database schema, so using the above examples...

Sorry about the formatting earlier, you need to see the READTEXT explanantion from BOL

USE pubs

GO

DECLARE @ptrval varbinary(16)

SELECT @ptrval = TEXTPTR(pr_info)

   FROM pub_info pr INNER JOIN publishers p

      ON pr.pub_id...

This example from books on line seems to give the answer?

Examples

This example reads the second through twenty-sixth characters of the pr_info column in the pub_info table.

USE pubsGODECLARE @ptrval varbinary(16)SELECT @ptrval...

I actullay just resolved this, I turned to DTS in the end, created an ActiveX task and used ADO and FSO. Out of interest it was to build an HTML...

Thanks Jeff at least it gives me a new angle, as far as I am aware xp_shell is enabled.

BOL states that Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.

So I have set users to be members of this role however, it only...

Looked at that, quite impressive, $5000 price tag a bit steep

As this was an automated process I used ADO in the end to extract the first row and left bulk...

Thanks Jeff, I had a feeling it might be after trying everything... The problem I have is that the file is about 1GB, mine too is an automated process so...

Just to shed some further light, I have put this file in a Hex editor and there is a valid line feed and carriage return after each line very confused...