Ben Sullins (9/24/2008)

---

Has anyone here discussed or thought about a system for creating your own readable error messages. I'm at a point now where my team and I have developed...

Yes...

This is from a personal email. I choose to post any personal emails and answers to the forum which they apply so that everyone can benefit. Oh and...

Yeah, I like screen shots too, but the OP sounded capable enough to find it without the screen shot. Usually if I'm wrong I do screen shots in post...

Ahhh, I was first by seconds. Probably because I didn't provide the screen shot.

Check the recovery model on OpManagerDB. It has to be FULL or BULK-LOGGED to do a log backup.

You can do this 2 ways. The first way will make it apply to all query windows.

1. In SSMS go to Tools -> Options then to Query Results...

1. The service account user just needs to be a normal domain user. If you assign it during install or using SQL Server Configuration Manager it gets assigned...

Please don't cross post. There is an identical question here: http://www.sqlservercentral.com/Forums/FindPost575007.aspx

with one post in it as well.

Sorry, I was trying to figure out why you had the * 100 and now I know. You need to remove the *100. The code should be:

set @weekNum...

You are using all numeric types to you won't get the result you want as 2008-43 is a character type, not a numeric.

I'd change @WeekNum to char(7) and then when...

The package did not fail?

Seriously, how many steps in the package? Do all failure routes go through the SendMail task? Is the SendMail task where it is failing?

RP_DBA (9/24/2008)

---

I generally like to avoid using ORs in my WHERE clause so I modified your statement to use an AND. Check out the query plans for these two and...

david.gray (9/24/2008)

---

Hi,

Yes I've tried both 'TEXT' and 'HTML', makes no difference.

I sent the email to a collegue, they did not get the first error but go the...

You asked about breaking it down into smaller modules and the...