We got bear with each other. I am try to help while also doing my own job as well (along with the normal day to day distraction that occur).

one...

You haven't answered the other question yet, is it possible to capture the data in these tables when SQL Server restarts?

Michael Earl (11/25/2008)

---

Great Lynn, take "should I use identity columns for a primary key" - a subject that will on it's own cause rage-full people to spew out angre messages...

Standards are great, everyone should have one.

Unfortunately, there is a single standard for this. Each business or organization tends to develop thier own standards for doing development work.

Can you move the file(s) local to the server you are attempting the restore and try it from there?

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...