Thanks for spotting that. I'll try that out in my test DB and see if it is a more efficient method.

Appreciatively,

mtf

Thank you for the endorsement on Magoo's convert trick. I am going to adjust it so the final character isn't repeated and if I can get that to work, I'll...

Lowell,

That was just the ticket!

The select StripNonAlphaNumeric(name) produces exactly the ASCII without the UNICODE NULLs embedded. The update also seems to work in the testing I've done so far!!!

For...

Magoo,

I think you're right about how there are embedded NULLS between each character. I ran the series of convert functions you provided and it showed AHSGuest††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††.

I really appreciate you providing...

Magoo,

For the 'AHSGUEST' value, here's what I see:

select id, name, DATALENGTH(name) as 'thedatalengthName'

FROM my_user_table

WHERE id='123'

123A30

mtf

Lowell,

Sadly, this isn't matching any rows:

select id, name

FROM my_user_table

WHERE CHARINDEX(name,CHAR(0),1) > 0

No rows returned. Likewise, the replace operation doesn't touch any of the rows. Ideas?

Thank you very much for...

Hey, that's a pretty cool piece of SQL! Thanks for offering it.

I think the +1 helps it traverse the string, but honestly, this is using some structures I've never even...

Thanks for the info. I think this is my last question....

Should I rebuild the indexes after every incremental shrink?

-- mtf

Thanks for this script. What values would you to call the script if you wanted to shrink it in a 1GB increment?

-- mtf

This issue has been SOLVED.

I checked the SQL Server Logs and found the following error message:

an attempt was made to send an email when no email session has been established...

So the goal here is to actually change the owner rather than add the user to the...

Wow. What kind of maniacs embedded that hidden pitfall into...

Jason,

Thanks for the reply. I just now checked the operator (myself) and the enabled check is in place. No pager duty schedule settings have been made. I checked the 'notifications'...

Lowell,

When I execute the syntax you suggested, it seems to never complete. Should it really take a long time for this stored proc to finish?

USE <database name>

GO

exec sp_changedbowner 'DbViewerTesting'

mtf

Lowell,

I received permission from the organization here to allow the customer user to be dbowner. I thought I'd try the method you suggested in this snippet, but I receive an...