Gianluca, thanks for the responses.

If you only need Execute permissions on the stored procedure to run any code within it, then what's to stop someone who has execute and edit...

ColdCoffee, that helps very much. Thanks for taking the time to write that!

Thanks, John. The reason for so many INSERT statements is that I scripted the table using SSMS, so it, by default, prints an insert for each row to be added...

ColdCoffee,

Yes, it works. I must have been doing something a little different. Anyway, the one piece I think it's missing is a line that has Joe, ST, CoveredByBase, then all...

ColdCoffee,

Thanks for the response. Unfortunately, the query you wrote doesn't return any rows. I wonder if there's something going on with the HAVING clause.

Actually, I may have figured it out.

I think what had happened is that I originally created a login Domain\Sales, then mapped a user with the same name to 'Reporting.' Then,...

Are you sure? I can click on...

Ok, here's what I did:

1) I disassociated "Domain\Sales" from the "Sales" database role (that way I could test the user itself).

I tried logging in as Domain\testuser and received an error...

I created a test AD user and added it to the Domain\Sales group. Then, I started another instance of SSMS by using Run As... and specified Domain\testuser and its password....

calvo (5/10/2011)

---

First, make sure your instance is in Mixed Authentication mode.

After this is done, you can create a new login specifying a windows account (or group). Search for the windows...

Ninja's_RGR'us (5/2/2011)

---

The "simple" way is to create groups and assign permissions to those groups. Then add the users to that group to get all the permissions.

That's the easy part....

<> 'A' would only exclude the one record where Status = 'A'. I want to exclude the entire person if any of his/her records have a status = 'A'.

GSquared (3/1/2011)

---

Then you're looking at two tables. One that joins majors to programs, one that joins years to programs. This could be a Majors table that has an...

GSquared (3/1/2011)

---

You need one table with each row having a Program, a Major, and a Year. It will have one row for each year a major was included in...

GSquared,

I'm not sure you're looking at this the same way that I am. You said:

Here's part of what you posted as a sample result:

Program,Year,Major

Education,2006,Math

Education,2007,Biology

Education,2008,NULL

Education,2009,NULL

Education,2010,NULL

Why would you only have Math in...