GSquared (8/27/2008)

---

I had a problem similar to this once when I forgot to tell the agent to use the DB Mail profile to send alerts. Is it possible you...

Weird ... I'm a local admin ... I just got done installing 2k5 standard and SP2 ... SP2 went fine, except for this one piece.

Yeah, the first two are taken care of in the above script and the account has access.

Steve Jones - Editor (8/27/2008)

---

This isn't really the place for this, and we don't want .SQLs up there for safety.

Adam, really you should submit this as a script, and there...

GSquared (8/27/2008)

---

Those three characteristics aren't persisted, because they only apply to the command being run on the index, not to the index itself. They're run-time options that have no...

Indeed, but when creating a new index, are these definitions for the index stored?

Jason, did my email go through?

Ok, lesson learned ... I had to use stored procedure for the command type instead of text.

So, I added a split function to handle a passed in value with comma's ... and still no luck.

Jason Wisdom (8/25/2008)

---

I...

So why bother with SQL? Sounds like VBScript would be a much better, quicker, and cleaner solution. Is the date derived from a table or something?

Jason Wisdom (8/25/2008)

---

Okay. We could be very close to a solution here.

How can an ActiveX step, using VBScript, execute...

I don't believe so. Again, why not use an ActiveX job step and use VBScript if you really want to handle this in SQL?

Unfortunately the WMI counters accessible in SQL do not include this, but your best bet would be to poll the WMI counters and dump them into a table.

Jason Wisdom (8/25/2008)

---

Yes.... I never use xp_cmdshell anymore.

Is there ANY other way to pass...