In some way, someone, somehow granted permissions to the public role. At least, that's the only thing I can think of that would do what you're describing. May...

I tried saving those as sqlplans, but got XML errors from them. Can you save them as sqlplan files, zip them up, and attach them here? That would...

The information you need does not exist.

Or, jumping to conclusions because of the object names:

La información que usted necesita no existe.

The only reason I use a script instead of a proc is if I never expect to have to run it again. Even then, I'll often save it as...

I guess it depends on what the end-user needs it for. Sending it as a single-table database works, if they want to query it and all that. If...

I love the chops t-shirt thing! That is just way too... too ... well, it's whatever, but I love it!! 🙂

Thanks Noel and Jeff. I appreciate the critique and compliments. 🙂

Lukk: definitely agree with you. One of my biggest concerns when I left the job where I built this hybrid hierarchy was whether or not anyone left behind would...

Have you speed-tested the queries on that against nested sets hierarchies?

danielk1: yes, that's a "nested sets" hierarchy.

For something like your sample, it's definitely the way to go. It's not likely that "Meat" will ever be moved out of the...

chileu17 (1/27/2009)

---

What I am expecting to get is that a user without any privileges on tables, but only on a exec of a sp, gets an error trying to execute...

When I saw the "new" article, I noticed that the sub-headings were the same, and just assumed it was a re-post of the older article. Didn't even notice that...

I've played with the SQL 2008 hierarchyID data type a little bit, but only a few minutes, and I've never used it in a production environment.

I have tested pre-2008 path-hierarchies,...

What you need to do is use the "complex" case statement, instead of the "simple" one.

The one you're using, where you have the column name right after the word "case",...

I'm not familiar with SQL 7, but I can definitely say that in 2005/8, you can give someone execute permission without also giving them the ability to view/edit code in...