Tom Van Harpen (8/22/2012)

---

I think we tried the ownership chaining before but in this case the query is hitting a table over a linked server and the impersonated account is...

mtassin (8/22/2012)

---

I've just run into one thing with it... I figure I'll ask you before I go to Darren.

I left a process with the filewatcher watching a remote share

\\server\share

We copied...

Bobble

Divulge

I am not sure you can target the x86 platform and have it run within an x64 instance as it will be executing in an x64 thread. You could target...

I doubt it, but if it makes you feel any better I can recreate your issue on Windows Server 2008 R2 and SQL Server 2008 R2. I created a Local...

How is it going?

Excellent. Thanks for posting back that you were able to resolve the issue.

mtassin (8/21/2012)

---

Thanks,

The Konesans' task is just what I needed.

Normally I'm pretty nervous about 3rd party plugins for SSIS, but this is the right tool for the right task in...

You're welcome. If it stays in the realm of databases you're probably OK, i.e. in the same boat most of the rest of us have been at one time or...

Good, at least someone set it. It's impossible for me to say if that number is appropriate because it will depend on what else runs on the database server.

Chapter 4:

Troubleshooting...

I like the Read Committed Snapshot iso level and recently enabled it in a database supporting a vendor app that could not be modified and it worked wonders.

One other angle,...

tonyclifton77 (8/21/2012)

---

thanks for the explanation.

I've tried setting up my project like your sample pic, but I only looped for 5 times. However I get an error when I put two...

In addition to Linked Servers (including adhoc uses via OPENQUERY, OPENDATASOURCE and OPENROWSET) calling an external app using xp_cmdshell can be affected if the called apps cannot run in a...

That will give you Fixed...