Based upon what you have stated, then you need to have the Product table joined three times.

I don't think your problems with the query are due to the multiple joins....

That is exactly the reason why we perform full backups, differentials and transaction log backups. The more frequent the transaction log backups - the less data loss.

You could always...

From your narrative - I am not sure that what you want to do is possible. Review the article in my signature to see how to post and get...

I don't think it is necessary for Paul to answer - I just wanted to note that using the data purity option invokes additional checks.

From the documentation, those checks will...

GilaMonster (1/18/2009)

---

For what it's worth, if I had that error on a production database, I'd pick the second option if it was feasible (due to time constraints). Or you can...

The @query option has to be a query that is run. There is a parameter for including an attachment which is what you should be using instead.

Please look this...

Sean Lee (1/16/2009)1. Why is CHAR(8) wrong? Is it for space concerns? I used char(8) because in order to use the view, I need to do something like 'SELECT *...

Not sure I follow you - the UNC path would be: \\servername\{share name}. Let's say you have a mapped drive called T:. That mapped drive actually references a...

John Rowan (1/16/2009)

---

Just a note on #1 above, it is becomming a fairly common practice (at least in dimensional modeling for DW apps) to store the dates dimension with that...

We need to see the execution plan to verify, but here are a couple of things:

1) cDate in StaticDates should be stored as a datetime instead of char(8).

2) The index...

I would bet that there isn't a T: drive on the server. Even if there were, the Agent wouldn't see the drive because you cannot map a network drive...

mohammed moinudheen (1/15/2009)

---

Using sp_send_dbmail to send notifications is a good option.

But when I trying to attach an attachment I am getting this error message.

Failed to open attachment file 'T:\master\test_backup_job.txt'....

Glad I could help - your solution is one of the recommended approaches for solving this type of problem.

Okay, I have read through all of this - and I have to say I agree with Lynn. In fact, this is what I was trying to get at...

Not sure about the group - but I do know that having a group defined in Exchange will not work. The group usually has to be defined in AD.

The...