I'm pretty much a newbie when it comes to Sql Server, and I have a question as to how to constrain data in a table.

I have 2 fields, which are both bit fields. Any one or both must be set to true but both cannot be set to false.

Is this a constraint or it is the job of a trigger?

Thanks in advance.