Ok, so I got a scalar function that is being used in Check Constraints on many tables. Now say in the future I'd like to alter this function, I believe SQL server doesn't let you do this while the function is being referenced. So to do this you'd have to clear all the references, then make your changes, and then put all the references back. Is there any easy way around this problem short of doing this or making a new function?

...

Hello,

I was wondering if someone would know some methods that would help me store an object into a ms sql database. I've found lots of documentation on how to do this with files and images but not with an Object.

I was planing on storing it as binary data. What I am storing is results from sql stored procedures for the purposes of caching. Which would come in as DataTable and be taken out as DataTable, but any conversions...