Direct access to the data by most users is usually not a good idea. Some power users maybe.

The business needs to define what they want, what kind of information,...

The closest you could come would be to do an IF statement checking the @@SERVERNAME and if it was right to run your code.. Thats about it..

CEWII

Do you add files a lot? Is that a major concern? Or is it a tradeoff you could make? If it doesn't happen a lot maybe you...

Is this SSIS or DTS? Or DTS on SQL 2005? It isn't clear..

CEWII

I don't think you understand what the proxy is doing. It is setting the user that xp_cmdshell will be running under in the OS. The SQL User has...

I would be REALLY careful with this, this is useful...

You are welcome.

CEWII

Config files are just files that are referenced. I guess I don't understand your question.. You can copy the files to wherever you want them to go, preferable...

I have to say I truly detest the SSIS deployment utility..

I no longer use it. I build scripts using DTUtil to copy the DTSX files up into the Integration...

GilaMonster (9/1/2009)

---

If that happens, I would take a long, hard look at the IO subsystem, especially at the disk write cache and make sure that it's properly battery-backed and that...

I agree, good article, with only one real type that was easy to fix..

CEWII

This was especially true in 2000, almost without fail if I killed a process and it was in the middle of a rollback and then I killed the server it...

Could you post a coherent question? I'm not sure what you are asking for?

CEWII

So in other words, be nice, even if the answer is that was a really stupid thing to do? Over the years I've inherited many peoples great ideas and...

The use statement that you specified is not going to ever help. The OSQL command executes in its own context, and will go to the default database for whatever...