I tried that, still isn't working:

IF EXISTS (SELECT * FROM dbo.SysObjects WHERE Name = 'UDFDemo' AND XType = 'U' AND USER_NAME(uid) = 'dbo')

DROP TABLE dbo.UDFDemo

GO

CREATE TABLE dbo.UDFDemo

(

...

Thanks for all your help SSC, but unfortunately the solution you posted is missing one criteria inside the UDF. I am not comparing values soley, but also making sure...

Those are both possible solutions, but does anyone know why using a CHECK constraint that calls a UDF wouldn't work? Perhaps I am calling it incorrectly or something else is...

Good point, but, the UDF is more complicated than my example. It needs to only kick out dups if the order meets a certain criteria.

For example, my...

You can use the built in SP sp_trace_create in a stored procedure to create a trace specifying a stop time. Check it out and others in BOL. There...