I too am going to second Grant's position. I just can't go along with the "we might need it" position, you need to be smart about moving data around....

Hm, so we are talking about a multi-tenant situation. And they can RDP into the box. I've got to say I wouldn't allow the RDP, it is probably...

Mike C (9/24/2011)

---

* If you are going to stay with the current methodology (50 threads pounding the same table with SELECT ... INSERT) simultaneously then you're going to want to...

Hm, interesting..

try this:

exec master..xp_cmdshell 'C:\"Program Files"\7-Zip\7z.exe a "D:ew.7z" "c:ew\"'

It appears to work.. don't like it, but it...

Or a login audit or a trace of the login events.. several things are possible..

CEWII

How about:

exec master..xp_cmdshell '"C:\Program Files\7-Zip\7z.exe" a "D:ew.7z" "c:ew\"'

CEWII

Open the package in BIDS, rename it to something else, when it asks to rename the package object tell it yes. Rename it to what you really want it...

I seem to remember seeing this when I built some machines that were on VMs and the SQL boxes were built from the same base image as the AD controller.....

I'm a little confused by this as well.. Why are you even managing the restores yourself.. Log shipping should be keeping the other end current with the most...

While you can do that I would absolutely NOT use linked servers to reach out to a bunch of servers to perform activities, I would use SSIS to do this.

CEWII

Please don't post effectively the same question twice.

Please respond to http://www.sqlservercentral.com/Forums/Topic1180658-364-1.aspx

CEWII

I like Gila's answer..

CEWII

Nope, sorry, they just aren't.. And I wouldn't expect that to change anytime soon..

CEWII

Mike,

I generally agree, not sure what the purpose is for the hash here. I usually use it for change detection as well or in some cases where I need...

Good catch on that.. The fact that...