I would move them to using Windows authentication, and then setup groups that you then use to assign permissions.

Matt Miller (11/25/2008)

---

Lynn Pettis (11/25/2008)

---

And I would be careful when looking at natural key as a primary key. What might be unique and unchangeable today may not be so...

Just like I said in your other post, read this: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Follow its instructions, and you will benefit greatly from the positive responses you will get from your post(s) for help.

Neither...

jacroberts (11/25/2008)

---

peter (11/25/2008)

---

jacroberts (11/25/2008)

---

Adam Machanic (11/25/2008)

---

You're absolutely right! Why do you suppose that it happens to be...

YSLGuru (11/25/2008)

---

Lynn Pettis (11/25/2008)

---

Actually, you are getting out of the fog. Now that you are getting more into the What is need to be done, rather than how it...

Based on your earlier posts, I also assume that the records are fairly narrow, would you say under 128 bytes each?

And I would be careful when looking at natural key as a primary key. What might be unique and unchangeable today may not be so tomorrow as requirements change....

Actually, I do have a question about the table(s) that you need to do this for, and it is very generic, how many rows of data in each of the...

Actually, you are getting out of the fog. Now that you are getting more into the What is need to be done, rather than how it is starting to...

Not sure which forum you should have posted this to, but as a "newbie" I'd like to start by having you read the first article I have linked below in...

If I have the time, I'll try. I have few issues right now here at work that I have to figure out.

Doesn't mean you need better english, just better information. The DDL for the tables, sample data for the tables, expected results based on the sample data. All this...

GilaMonster (11/25/2008)

---

I didn't ask for the entire proc. I said, if you want us to do all of the work for you, give us table definitions (as create table statements),...

Check your share permissions.

YSLGuru (11/25/2008)

---

To perform the following command which is using pseduo names because an NDA disallows my...