Thanks to everyone for their answers! I know your answers are not intended to say "you should go to SQL 2016," but I appreciate the feedback consensus, which I did...

TheSQLGuru (4/5/2016)

---

You didn't give us anything at all to go on to advise you. In particular what edition of SQL Server are you on now and are you (or could...

Thanks for the question. I learned something!

- webrunner

Thanks all for your replies! Especially given the crazy nature of the file setup. I think I have enough advice to figure out what to try (the idea of populating...

Thanks, great question. I incorrectly chose 0 but learned something.

- webrunner

Thanks for the question. I didn't know that.

- webrunner

sknox (2/23/2016)

---

...

The check constraint process isn't "I only want you to insert values that are in the following list", but "I want you to refuse values that fail this test"....

Thanks - great question.

- webrunner

Thanks for this info, Steve!!

- webrunner

Thanks!! That is a big help.

- webrunnr

Brandie Tarvin (2/12/2016)

---

webrunner (2/12/2016)

---

I eventually found out what was happening.

I was using @[User::Variable] = 0 instead of the operator to check for equality @[User::Variable] == 0. Once I fixed that...

Thanks for that advice - I'll definitely check it out.

In the meantime, for this problem, I eventually found out what was happening.

I was using @[User::Variable] = 0 instead of the...

Brandie Tarvin (2/12/2016)

---

A great way to impress your boss is to create a daily or weekly "Entitlement" report that documents these permissions in all environments. Have the report dumped to...

Great question, thanks!

- webrunner

Nice question, thanks. I missed Endpoints.

- webrunner