Thanks for the reply; I looked at CTE help in SQL Books, but that didn't help because the method they mention is having only one 'anchor' member (one base member...

You guys are awesome; I recreated those faulty functions/procedures, ran dbcc checkdb with_purity and everything works great now!

Many thanks again for all the help.

Thanks for the advice, it is greatly appreciated. One question -- how do I properly drop and recreate the stored procedures? I mean, what is the process one would...

Okay, great. Because the DB is located at a retail location, I'll wait until after business hours, run the commands, and then post the results.

Thanks for the reply; can I run that command at any time, without affecting users accessing the DB? or do I have to run it in single-user mode, etc?