You've definitely given me some food for thought here. I actually may try to dynamically create the attributes but like you said it would probably get ugly. I...

My bad I didn't make myself clear enough. In the extraAttributes table I have over 130 distinct attribute_names (I just used 'COLOR' and 'SIZE' as examples) and more will...

No need, it now works for the other user as well. When I get the chance I'll test it out and see if that is what was causing the...

I moved the stored procedure from the user database to the msdb database. Now when I execute the store procedure it works. I haven't been able to have...

It's been executed both as domain\login (me/sysadmin) and as the user I'm trying to create the stored procedure for. Regardless of who executes the stored procedure the error message...

I checked and the server/service had not been rebooted/restarted. No other error messages either around that time.

Could high CPU usage cause this?

Thanks,

Mike