title: T-SQL check constraint for .NET TimeSpan?
body: <p>I have a nvarchar(max) column in a sql server 2005 table which is used for storing string representations of .NET TimeSpan objects. Sometimes the table is manually edited. I want to add a check constraint to verify that the string can be parsed by TimeSpan.Parse(). How should I do this? I guess I could use one of the methods for enabling regex in sql server, but I'd like to find an easier way if there is one!</p>