What you call your tables is ultimately up to you. You're the one who's going to be using and supporting it.

There are several approaches to design something like this....

Michael L John (2/9/2016)

---

How many actual users exist, and how are the permissions configured?

It seems as if generating a script to remove or disable users that exist in production, and...

Lynn Pettis (2/9/2016)

---

Phil Parkin (2/9/2016)

---

Lynn Pettis (2/9/2016)

---

Who has the Crystal Ball??

Silver Spoon(2/9/2016)

---

I Get the following error when attempting to Configure Distribution on a SQL Server 2014 Machine

ServerName\Instance Cannot be configured...

A separate notes table for each table that can have zero to many notes for each row in the parent table is the correct design. It's pretty-much exactly what...

Big

Steve Jones - SSC Editor (2/9/2016)

---

Me too, which is why...

Tractor

That was a good one - it had me wondering what I did wrong for a little while.

World

Sean Lange (2/8/2016)

---

Ed Wagner (2/8/2016)

---

Jack Corbett (2/8/2016)

---

Sean Lange (2/8/2016)

---

Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found...

If you do a lot of work with delimited columns, you'll want to spend the time to read the article that...

Lean

Jack Corbett (2/8/2016)

---

Steve,

Good editorial as usual. I think you sum it up well in the last paragraph:

The mark of a good manager is that they find ways...

Jack Corbett (2/8/2016)

---

Sean Lange (2/8/2016)

---

Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is...

Fried Bananas