jasona.work (3/10/2015)

---

SqlSanctum (3/9/2015)

---

jasona.work (3/9/2015)

---

SQLRNNR (3/9/2015)

---

jasona.work (3/7/2015)

---

Turns out, Public by default does not have CONNECT SQL. So I was thinking I could grant the privilege to Public, then revoke it...

jasona.work (3/9/2015)

---

SQLRNNR (3/9/2015)

---

jasona.work (3/7/2015)

---

Turns out, Public by default does not have CONNECT SQL. So I was thinking I could grant the privilege to Public, then revoke it from the...

Jeff Moden (2/24/2015)

---

Thanks folks. Has anyone any particular pleasantries that have occurred from Dev to Stage to Prod with RedGate Compare?

@Lynn...

Are you saying that you had to...

Brandie Tarvin (2/13/2015)

---

SqlSanctum (2/13/2015)

---

Ed Wagner (2/13/2015)

---

Gazareth (2/13/2015)

---

Brandie Tarvin (2/13/2015)

---

SqlSanctum (2/13/2015)

---

Koen Verbeeck (2/13/2015)

---

Brandie Tarvin (2/13/2015)

---

Gail and Jeff, I really want to thank you for your input on the SQL Server licensing...

Ed Wagner (2/13/2015)

---

Gazareth (2/13/2015)

---

Brandie Tarvin (2/13/2015)

---

SqlSanctum (2/13/2015)

---

Koen Verbeeck (2/13/2015)

---

Brandie Tarvin (2/13/2015)

---

Gail and Jeff, I really want to thank you for your input on the SQL Server licensing issue. Not only...

Koen Verbeeck (2/13/2015)

---

Brandie Tarvin (2/13/2015)

---

Gail and Jeff, I really want to thank you for your input on the SQL Server licensing issue. Not only were we able to get Developer...

Assuming I understood your original question, here is a simplified example, per your request. I used information schema to get the answer. Try to rewrite it using sys.tables & sys.columns...

If you use sys.tables and join to sys.columns on object_id, you can use COUNT on the column names or ids to get the total. Max_Column_Id_Used in sys.tables would give you...