Yes, if I run the query through Artisan I get the message outside of the Stored Procedure. (I just ran it through Query Anal (QA?) to see if it might have...

FYI, joins did not work.  I guess the only thing I can do is call Microsoft, yipee.

I can ask the server admin do that.  Of course he will tell me that everything went fine and it is a waste of time.

Any idea where I might find...

The error is more than likely a server, table or index issue.  The sp ran fine until the latest service pack was loaded.