Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to set a unique key on a bit field RE: How to set a unique key on a bit field

  • June 16, 2011 at 12:34 pm

    #1339979

    GSquared (6/16/2011)

    Ninja's_RGR'us (6/16/2011)

    Are you on 2k5 or 2k8? I ask because poeple often post in the wrong forum.

    Assuming 2K8...

    Wouldn't it be possible to create a unique filtered index to avoid the pain of the triggers?

    Yep. That's another way to do it. Thought of that, but assumed that 2k5 forum was picked for a reason.

    Agreed... but I've seen something like 4-5 "wrong version" posts today so I just figured I might talk about it ;-). Not to mention that I don't always post the version in google so all in all an ok call in my book. :w00t: