Ed,

Are you sure about UAC as it relates to xp_cmdshell? I seem to have seen that the two sets of rights that we see interactively is not true when...

Yes, it is.. An EXISTS check completes as soon...

First, the only way I know to do it is using an undocumented (read as: MS doesn't recommend you use it) extended stored procedure.

Look into xp_instance_regread

A quick way to see...

Domain account is fine, a domain *ADMIN* account is not.. And MANY people add the account that SQL runs as to the local admin group on the box. ...

Ghanta (1/8/2011)

---

Thanks guys for the response... I was able to do this using Conditional Split Transformation and Derived Column in SSIS... basically all that tedious substring, I had to write...

JeremyE (1/7/2011)

---

A big win for Litespeed is the ability to do object level restores. Restoring a single table or proc is much easier than restoring an entire TB sized database...

Having dealt with this before..

I only want to read the file in once from disk.

I would review the BULK INSERT command. That gets the data into a...

My SSIS recommendation stands.. It will also help you get the data to disk when its time.

CEWII

I would think WMI would be able to query out all that information..

CEWII

OH SNAP!

CEWII

sqldba_icon (1/7/2011)

---

GSquared (1/7/2011)

---

The problem with xp_cmdshell is that, if the account privileges are set even slightly wrong, it allows all kinds of nasty things to be done to the server.

It...

Craig Farrell (1/7/2011)

---

Elliott, I'll have to disagree with you here....

I would probably do this with an SSIS package using a script task in the data-flow to format and breakup the text. It would also probably perform better. ...

I have to partially disagree with you. I have seen "throw it all at the optimizer and let it figure it out", I have seen monster 8, 12, and...

Interesting reading.. But at ~$1500/server I don't think I could stomache it for any but the most obscenely large database servers.

The smaller backup files than native with...