Step 1: what command is it executing?

Actually, I believe that this could also be done either with Service Broker or through Event Notifications.

Nonetheless, I agree that a SQL Agent Job such as Jeffrey is describing is...

Jeffrey Williams (12/21/2008)

---

RBarryYoung (12/21/2008)

---

Pradeep's point is well taken here: There is no point to backing up the database immediately after it is created, because it does not have any...

Heh, tough question. should be more than one point! 🙂

Pradeep's point is well taken here: There is no point to backing up the database immediately after it is created, because it does not have any data yet. ...

And why can't you use SSMS for this?

I am pretty sure that John Marsh has the answer there. Looks like the OP incorrectly quoted the parameter's name in the WHERE clause.

Fiddler (12/17/2008)

---

I put the same criteria in a case statement for my DELETE query using NOT, but no records at all are returned, although it does compile. Can you...

Thanks, Steve. Stuck at home alone with a bad cold here on Christmas Sunday, I am definitely waxing philosophical. 😎

barbararyan (12/21/2008)

---

Also, there MAY be a need to examine ALL activities (i.e, including all orders, invoices, etc.). We may add a few more columns to the Activities table(s) ---...

Relational design...

Ah yes, typology is always good for a donnybrook or two...

Well, I got it wrong, but I am going to go with Steve on this one. The issue as...

GilaMonster (12/21/2008)

---

Meaningless marketing drivel. I doubt the people who though that up...

Yes, but Microsoft is the one who started this "Beyond Relational" campaign with SQL Server 2008. And it is Christmas... 🙂

This is the flaw in your design: there is no reason in relational design that you should...