Helen,

Thank you!   I used something similar to what you wrote and it worked.

DECLARE @In nvarchar(250)

SET @In = 'Baxter Lane (BLANE)'

SELECT SUBSTRING(@In, CHARINDEX('(',...

Good point!  But it is a little more complicated than that actually.  The developers built an app that takes encryped credit card data and decrypts them.  They run this app...

Thanks for your help!

That worked!  I actually changed the statement to update the response field only and empty out the data.

Thanks!

Mean Old DBA,

I'm trying to delete data from the "Response" column based on whether the "Completed" column has a status of '1'.  It should only delete the "Response" column data if...

Sounds like a good idea, but I'm not very familiar w/ c# or vbscript.  Is it worth my while to become familiar w/ these languages to accomplish these tasks.  I'm...

I suggested using WITH (NOLOCK) for our SQL process to one of my developers and he had concern that it reads uncommited data.  Because we produce a file from this process that...

I used WITH (NOLOCK) in this query.  I'll test it and see how it works.  Thanks for your help.

Grasshopper,

Yes, I actually have restarted the SQL Server services.  It resolves the prob temporarily, but SPID -2 still seems to show up as BLOCKING from time to time again.  And...

I agree w/ you also.  I thought this was the easiest way to make the mod.  And I also answered using EM and it said I was wrong, I tested it...

Thanks!  I've actually been researching this.  I'm assuming I need VB 6 to run this script, right?

Chris,

Excellent article!!!  After reading your article, I checked w/ our Sr. System Developer to verify if we are using these techniques.  We are looking in depth to other exploitations of...

Chris,

Excellent article!!!  After reading your article, I checked w/ our Sr. System Developer to verify if we are using these techniques.  We are looking in depth to other exploitations of...

Chris,

Excellent article!!!  After reading your article, I checked w/ our Sr. System Developer to verify if we are using these techniques.  We are looking in depth to other exploitations of...

Chris,

Excellent article!!!  After reading your article, I checked w/ our Sr. System Developer to verify if we are using these techniques.  We are looking in depth to other exploitations of...