you DA BOMB!!!

UPDATE dbo.table

SET MyColumn = replace(MyColumn, 'mages/pubs/columbia', 'en/graphics/columbia')

where MyColumn LIKE '%images/pubs/columbia%'

worked like a charm.

Tried

Update dbo.table

Set MyColumn = replace(pageImage, 'images/pubs/columbia', 'en/graphics/columbia');

and

Update dbo.TableSet MyColumn = replace(pageImage, '%images/pubs/columbia%', '%en/graphics/columbia%');

Both Changed ALL rows in the column instead of just the...

awesome! I'll give it a shot!!

i have 7ZIP 4.6.5 and I don't have the LZMA2 option in 7-zip ????

7Zip is the way to go

The MDF grew by several GB.

Thank you for the tips. I'll check them out.

I did take a full backup after and I will defrag the indexes.. Thank you : )

any suggestions for getting the backups any smaller ?

I found out what the problem was. Bad input file!! got a new txt file this week and it ran through fine.

took the old file and...

received the same error. The error is on a bulk insert - with transformations - into a table from a 1.6GB text file.

We are going to try...

Ran this:

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

sp_configure 'max server memory', 6144

RECONFIGURE

GO

EXEC sp_configure 'show advanced options', 0

RECONFIGURE

Still only using 5GB of memory. Cycle the instance to take effect??...

sp_configure 'min server memory', 1024

RECONFIGURE

GO

sp_configure 'max server memory', 6144

RECONFIGURE

GO

Do you know if this will require a reboot? I'm assuming I would just apply this change to my active...

Thank you !! So you think that increasing the MAX memory to say 6GB from 5GB might do the trick?

I will use the hotfix is nothing else works.

One problem I fouund is that SQL Server 2005 Standard Edition on a 64bit

System does not support Lock Pages in Memory without CU 4 for Service Pack

3. ...

another thing I have to considered.. our legacy DTS packages work fine with production volume data on our Production system which is sql server 2005 on 32bit (also clustered)...