Me thinks you will need to repost your question here on this thread, complete with tables, sample data, and expected results.

Nice.

I also liked his responses to your posts. He answered your questions, provided sample data; all in...

Ya think? :w00t:

The autoincrement column would be a primary key. This key would not be visible to the users, just to the database. It would be used to link related...

Here is the last thing I would with the code. In your select list in the UPDATE statement, I would alias the column names with the table aliases from...

Lucas Davenport (11/25/2008)

---

There is another option . . . .

Set the SQL Server so that changes may be made to system catalogs (RC Server in EM, Properties, Server Settings)....

AND, show us what your expected results should like like from the query. Nothing you have posted so far helps us understand what you are actually looking for in...

Also, don't just edit your post, add a reply to it. If you just edit your original post, no one but you will know that you did, and your...

First, yes, you should read the article that both Seth and I have in our signature blocks. It would make working on your "opportunities" easier. Luckily, things are...

Michael Valentine Jones (11/25/2008)

---

In that case, let me jump in. 😀

There are many opinions of this subject, but I am...

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?