In SQL Server 2005 it's actually at the individual column entry level on a row, not even at the column or table level, much less the database level. So to...

Are these Windows or SQL Server logins?

This looks like a cross post that I just noted. See my reply in the other thread.

We've run into it ourselves and try to keep them short as a result. Yeah, I agree... but what can you do?

dan (3/26/2008)

---

Just a thought, but with the addition of the need for the windows group SQLServer2005SQLAgentUser to have SQL sysadmin permissions in SQL 2005, doesn't this create a fairly large...

Richard Lu (3/26/2008)

---

I agree follow-on article(s) should be added.

As to the unexpected fail-over, it may indicate that there is a problem/situation in the cluster causing the is-alive check giving false...

The problem isn't price. It's time. Life-work balance...

Marios Philippopoulos (3/27/2008)

---

rbarryyoung (3/26/2008)

---

Marios Philippopoulos (3/24/2008)

---

Good luck. Make sure that...

Coyote Blue (3/25/2008)

---

Be very glad it is not a SQL7 cluster... I had to un-install SQL7 from a cluster (remotely) and after 8 hrs on the phone with MS tech;...

Marios Philippopoulos (3/24/2008)

---

Thank you!

This problem rears its ugly...

He's avoiding the double-hop issue by switching the security context. Previously you were doing this:

client -> web server (as Windows user) -> SQL Server (as Windows user)

now you're doing this:

client...

rbarryyoung (3/22/2008)

---

Marios Philippopoulos (3/22/2008)

---

Connections are made using the login's current security context.

So in the following query, the login running the query is the same account in whose context the connection...

If any lawmaker has a right to claim it, he does. I remember back...

I'm not thinking straight, I blame my sinus infection. Yeah, that's it. I only wrote that chapter in the how to cheat book. Egads.

Use a DDL trigger. You can rollback...

DDL Triggers. If they have ALTER, there's really no other way.