The report needs to get real time data. Subscriptions don't really work since the users will pretty much always run the report with different parameters every time.

opc.three (10/13/2011)

---

Personally I think using the CLR functionality to access files from with a T-SQL context, while preferable over using xp_CmdShell, is still a misguided application of the CLR. It...

In most of my environments, I was able to talk people into using methods like jobs, service broker, SSIS, etc. But in most troublesome environment - the one that...

I agree with most of what you said...

I agree with this. We now have a policy here at work: we do not purchase software that requires the usage of xp_cmdshell, along with other things too, like...

opc.three (10/7/2011)

---

jasona.work (10/7/2011)

---

I have setup something that uses xp_cmdshell, although now that I've improved my knowledge and skills with SQL I can see other ways to do this without xp_cmdshell....

Be harsh all you want or need, it does not bother me. I'm a big fan or honest words.

As I sit here, I have no less than 8 books...

We have a sql server here that the data drive is an iscsi drive (it's a dev box that gets little use).

Sometimes there'll be a hick up between the server...

I'm horrible with names, unless they're people I interact with a lot....

JamesMorrison (10/6/2011)

---

mendesm (10/5/2011)

Don't take this personally, but when a resume comes my way with "MCITP/MCTS" and other MS certifications I pass the resume on to the trash barrel.

These days, the...

sturner (10/6/2011)

---

Yes. We use RAID 1 for tempdb on most our servers, the rest have RAID10 for size...

GilaMonster

So which is it?

Any resume with a certification goes into the rubbish bin immediately (the initial statement)

A resume with certifications would be considered the same as one without and a...

GilaMonster (10/6/2011)

---

So you wouldn't...

The discussion is good so far.

I actually believe, there is no circumstance in which xp_cmdshell is required or the only way of doing something.

Whether it can be implemented securely, for...

Forget what Dell recommends. What's important is what your environment needs

If you have 5 sql servers in your environment and if one of them goes down because of the...