True, Calvin's and Greg's code is simpler but less flexible.

What if you only wanted to to delete multiple spaces?

i.e.

'Have a nice day!' to

'Have a nice day!'

...

What version of SQL Server?

Is this a production database?

Are you able to connect to the database server and not the database?

What tool are you using?

Are your NT services running? ...

All good info at that link but I'll stick to my tried and true...

If you can shut down the database I've always found that the quickest solution is immediately after...

That's exactly what I did in PHP and it worked fine. Although, it seems to me there was some other character that needed replacing as well.

I ran into this problem a while back. I was building an application in PHP that accessed a SQL Server database and one thing I included was a timestamped...

I made something similar and built it into a function

-- =============================================

-- Create scalar function (FN)

-- =============================================

IF EXISTS (SELECT *

FROM sysobjects

WHERE...

"...so, you might want to consider re-writing the whole schlamele from scratch..."

Best advice I've heard in this whole thread!

I've only done a few of these conversions and only one was...

Was this ever implemented?

It would be nice on the script screen to have a link to a forum thread or to start one. Often it seems that...

If you can shut down the database I've always found that the quickest solution is immediately after a full backup to use sp_detach_db, delete the physical log file and then...

Thanks for the input folks!

Feel free to continue adding your two cents.

Ok,

Peak traffic? - I don't have that info yet.

My business? - I'm new so I don't want to say specifically but let's just say that this is the database for...

Wow! I put a whole lot of 'guys' in that last post. I write goodly!

I don't think capturing a stream of IM's is workable. You'd get a ton of junk along with a few tips.

As for Andy's points about you guys monitoring it...

I realize it's similar to the forum but it has the added advantage of realtime communication.

Of course, the downside is that unlike the forum you would lose the...

Sorry, should have added that I would never try this on a production server.

My background was as a DBA at a software development shop and all but one...