rbarryyoung (3/30/2008)

---

It is important to realize that there are several types of Subquery:

1. Value Subqueries: These just return a single value per row and they look like this: (Select...

If I may make a minor correction...

SELECT bar

FROM serves INNER JOIN likes...

Posting 6 identical messages is not necessary. It wastes people's time and fragments replies.

Many of us read all the forums.

Please do not reply to this thread, but direct comments to...

Posting 6 identical messages is not necessary. It wastes people's time and fragments replies.

Many of us read all the forums.

Please don not reply to this thread, but direct comments to...

Posting 6 identical messages is not necessary. It wastes people's time and fragments replies.

Many of us read all the forums.

Please don not reply to this thread, but direct comments to...

Posting 6 identical messages is not necessary. It wastes people's time and fragments replies.

Many of us read all the forums.

Please do not reply to this thread, but direct comments to...

Posting 6 identical messages is not necessary. It wastes people's time and fragments replies.

Many of us read all the forums.

Please don not reply to this thread, but direct comments to...

In the properties of the maintenance plan you can set the plan to log to a text file. It will write far more detailed info than went into the job...

OK. it doesn't look like you have the DB engine installed, just the workstation tools. Do you know what edition you tried to install? (Enterprise, standard, workgroup, developer)?

Ok. Almost clear. From the looks of things, there's no need to create separate tables at all. Just one more thing....

Where does the email address come from that you're sending...

If I may suggest...

Read the article linked in Jeff's sig, then post the question again. It's probably simple, but I don't feel like guessing as to table structure and expected...

From what you've said, I would not suggest you consider a degree at the moment.

For the record, I have a B.SC and I'm currently studying for my M.Sc. so...

Maybe.

How many rows are in the table? What are the indexes on the table?

If there are no indexes, sql will do a table scan to find your rows. That means...

You can't restore a 2005 database onto a 2000 server. There's no downgrade option.

To install the DB engine, you need to get hold of the full 2005 installation.

What did you...

Depends.

If you're doing something like this, all will be rolled back

Begin transaction

set xact_abort on

update ...

update ....

update ....

commit transaction

If each update is within its own transaction (or if you're not explicitly...