Okay, I need some more info on this one. I don't see anything on the schedule that funny...

Congrats grampa! I'm hoping I'm at...

Jeff Moden (9/28/2013)

---

GilaMonster (9/28/2013)

---

Jeff Moden (9/27/2013)

---

Speaking of "Are the posted questions getting worse"?... I was going through some old responses to some posts and I came across this one that...

The problem is that you are declaring your variables outside the dynamic sql. sp_executesql changes the execution context so variables declared outside the sql string are not available...

I'd try but that tempDB thread has worn me out.

Nope, T-SQL job steps can't use proxies but they can use RUN AS which, if I understand correctly, uses EXECUTE AS in the background, so the user has to exist...

AlexMcCo (9/25/2013)

---

You do not need tempdb ndf file as large as you can make them. It is more than enough to put as 50 mb each. They will expand as...

You can specifiy the user the job step should run as, http://technet.microsoft.com/en-us/library/ms187358(v=sql.105).aspx

SQL Azure is not something you install, it is a cloud service offered by Microsoft, so you can access it from Linux since it is a cloud-service.

JediSQL (9/24/2013)

---

A major problem with dbmail is that you cannot specify the From address at run time; you have to set up a different profile for every From address you...

To me it sounds like a process that should use SSIS since SSIS is an ETL tool. I guess it could use BCP, but you mention that it "transforms"...

Looks like this isn't an uncommon problem. Here are a couple of links to go through that might help:

http://sql.nconsulting.net/2012/10/installation-error-mof-compiler-could.html#.UkLaLtXD-Hs

http://connect.microsoft.com/SQLServer/feedback/details/356258/the-mof-compiler-could-not-connect-with-the-wmi-server

http://connect.microsoft.com/SQLServer/feedback/details/357003/the-mof-compiler-could-not-connect-with-the-wmi-server

Please note I have not experienced this issue, but these links...

This is totally...

Those IO messages are normally associated with a backup process that uses VSS to do backups. Here's a blog post about it that has some links to some articles

Sean has provided probably the best T-SQL solution to your problem. If you aren't using stored procedures for your report in SSRS, then I would consider doing the splitting...