Are you trying to find changes that were already made, or are you planning for the future and working out options to track changes that might happen?

You're welcome.

Jeff Moden (2/1/2012)

---

drew.georgopulos (1/31/2012)

---

thanks very much

i just did, and it seems to be exactly the right model for this; as you observed, updates are rare, the levels are static,...

If depth is non-variable, you're better off building the table explicitly for that, and avoiding the more complex hierarchy solutions. All of those are designed to handle variable depth,...

At least the function definition would be needed.

TravisDBA (1/31/2012)

---

IMHO, a manager who punishes the whole group for the actions of a few is a very poor manager. They need re-training (or maybe just TRAINING, because a lot...

Here's a list of the views for security data in SQL Server: http://msdn.microsoft.com/en-us/library/ms178542.aspx

The ones you probably want are sys.server_principles, sys.database_principles, and sys.database_role_members.

Probably not, unless you've set up something to track that.

The usual ways to track that kind of thing are DDL triggers, traces, and source control.

To check for a DDL trigger...

For a HierarchyID structure on this, you'd end up with something like 1.M1A as the value for the first one. The nodes in a HierarchyID datatype can be strings...

Do you mean data changes in a table, or table definition changes (new columns, dropped indexes, that kind of thing)?

What precisely do you mean by "access profiles" in the original question? Server roles?

I don't see a data hierarchy in your code. What am I missing?

Ah the temptation to post a solution using Union All and a Pivot operator to avoid using Join! ...

To summarize, snapshot isolation, either flavor, takes rows that are being worked on (updated or deleted) and creates a snapshot of them in tempdb. It uses a row-version number...

mtillman-921105 (1/31/2012)

---

If I understand correctly, I think...