I haven't worked in an Oracle shop so I never heard the term before. The closest term I am familiar with is a "cold start" and that meant everything...

It would also be of great benefit if you'd actually provide the DDL for the tables, the actual create table statements. That way we only need to cut/paste/run in...

Nicole Bowman (8/20/2009)

---

Jason and Steve, here in Australia it is often written into employment contracts/is a condition of employment, that you do not take any other paid employment at the...

trudye10 (8/20/2009)

---

Not sure what you mean.

This may not be the smartest question I'll ask in my life time. But here goes:

I have 3 trailers, one trl doesn't have...

That would occur if you use an INNER JOIN. If there is a possibility of there not being a detail record, then you would change that to a LEFT...

Alvin Ramard (8/20/2009)

---

Time for an Off Topic item:

Can anyone suggest a user group website that would be a great example of what a great user group website should look like?...

See above your last post.

First in addition to adding a WHILE (condition) BEGIN END to your code, you will need a second FETCH NEXT just before the END in the WHILE.

However, I may be...

Let's see, do I have those tables? No. Do I even have any data for those tables if I had them? No. Do I even fully...

MAK (8/20/2009)

---

when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'. It is being used for FOREIGN KEY constraint...

You could detach each database, move the mdf/ndf(if any)/ldf files to their new location, then attach the databases.

Scripts like that are usually pretty specific to the database being copied. You might want to look at the Copy Database wizard for what you are trying to accomplish.

Grant Fritchey (8/20/2009)

---

Lynn Pettis (8/20/2009)

---

Kit G (8/20/2009)

---

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before,...

Kit G (8/20/2009)

---

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before, if you guys could...

Here is my first suggestion, start first by reading about these thngs in BOL (Books Online, the SQL Server Help System). It may not be the greatest thing since...