Ha, even worse ... the dev environment too. No other instances in this environment except for those which are for our intranet. The dev environment has it worse as I...

Well, isn't this interesting ... the test instance for this environment, also had almost the same error. The crazy thing is that the input buffer is showing my CheckDB proc,...

I haven't read each and every post, but have you tried issuing the alter to change the default size with a move as well? I had this same problem over...

Of course, I make a post and then a few minutes later fix it ... bah, I'm good.

I issued the alter to move and change size at the same time...

Might want to consider lowering that a bit ... If you're running other apps...

You can run 2000, 2005 and 2008 all together if you'd like.

As the previous posted stated, there isn't much of a need for SSMS '05 with the exception of if...

Assuming this is SQL Server 2005?

Do you have your max server memory set? If so, at what?

Indeed, just populate your variable appropriately ... but I do not really remember how cdosysmails works as I haven't used it in many years. IIRC it's similar to SQLMail in...

Could always try just running xp_sendmail as well ...

Putting maintenance plans aside, are you able to successfully back up the db and/or tran log manually? Are the failures at specific times? There could be one of many reasons...

llugo (6/5/2009)

---

We are already doing that with the alert/operator function. I am definitely looking for a more granular approach/solution. I know i could run a query against the...

Well, you could always test ... but AFAIK, you can not do this as SQL can not access disk that is not part of it's resource group and each instance...

If this is production, I'd always recommend running SSIS from another utility/app server, but regardless, you should set your max server memory settings appropriately to allow memory for the O/S...

KILL XX WITH STATUSONLY

XX = spid

llugo (6/5/2009)

---

I'm wondering if anyone knows of an easy way to pass the completion time of a sql job (after completion) to the subject or body of an email notification?...