You know, I work for a sole proprietor and am the only employee so, it's only me and my boss. I hardly ever see him because I am always out...

My point exactly and that is why I used the case for when I don't want to use the default. I will do some further testing with ASP.NET when...

Don't bite my head of now! I meant case when...

Look, don't get me wrong here. I absolutely believe in learning the hard way because that is the things you will remember most. You look for help in BOL and...

If you want to use a default date in that column then...

Erratum:

The following piece if code is incomplete and I have placed the correct code below this:

declare @datestring varchar(12)

set @datestring = convert(varchar(12),dateadd(d,-3,getdate()),1)EXECUTE master.dbo.xp_delete_file

The correct code:

declare @datestring varchar(12)

set @datestring ...

Grant, I have been motivated by your article and am trying this myself. I just have two things that I don't understand. You say that the last database backup was...

Focus is my problem. I am a hardworker and enjoy my work thoroughly. I set targets for myself as to what I want to achieve for the day. I also...

jcrawf02 (11/13/2008)

---

Look up datetime in BOL for an explanation of why, it's actually returning a value that is compared to 1/1/1900 00:00:00.

You should either pick a different default...

Steve Jones - Editor (11/12/2008)

---

There is some overhead to measuring the counters and logging them. If you have the graphical display up, this uses overhead as well.

you can use Task...

Did you do this part because if...

Prashant Pandey (11/7/2008)

---

Hi,

Thanks to all for giving your suggestions and thoughts, "Good comments always boost your confidence" but "Bad comments always boost your confidence to do the best as well...

If you followed the steps in the link I provide in a previous post and the solution that Jason Deyalson provided in a previous post (both in this thread) then...

sobrien (11/7/2008)

---

I wasn't being overly critical. I was stating my opinion. I found the article very hard to get through because of the way it was written; therefore, I got...

you need to make sure the mail profile is enabled in the SQL server agent properties.

right click SQL server agent -> 'properties'

select 'Alert system' then check 'Enable mail profile' under...