If you can use the SQLCLR here is an Aggregate Function I wrote to simplify the syntax for these types of queries that performs comparably (sometimes better, sometimes slightly worse)...

Which Oracle driver are you using? Are you sure it supports OLE DB parameter mapping?

A simpler option may be to build your SQL Statement using an Expression in a Variable,...

FWIW I tend to use RemoteSigned on new machines. It's a decent blend that lets me do what I need to do but is not completely open.

Indianrock (3/3/2013)

---

While it would...

You can use Agent Tokens in your log name.

Using Tokens in Job Steps- SQL Server 2008 R2

Change the log name to something like this:

X:\...path to log files...\filename_$(ESCAPE_NONE(STRTDT))_$(ESCAPE_NONE(STRTTM)).log

And you'll get a...

That error is saying that the service cannot start because the account set to run the service cannot log into the operating system. Check the Windows Services MMC and adjust...

Full or Evaluation?

I do not see 'Full Enterprise to Standard' here but you could try it via the 'edition upgrade' option in setup. It won't take long to find...

You can implement your own transfer using .NET in a Script Task. Here is an article showing how to do it in C#. You'll have to port the code to...

Disabling sa should be enough. I would forego the rename.

Looks like the same proc initiating the update so we can expect the same access pattern but the trancount is 2. What else was done inside the transaction, before the...

Two separate questions:

1) Who should own databases?

It does not matter if the Server Login that owns a database is disabled or enabled. sa is a good default choice to own...

What is the 'max degree of parallelism' setting on both systems and is the one that is having the trouble under heavy load in terms of how many modifications it...

You can add calls to RAISERROR with a...

mayur birari (3/4/2013)

---

Thanks everybody for your responses. I could not post the table structure etc because of policies. Here is what I found out after more testing.

From the execution plans,...

It was at a previous shop so I no longer have access to the code but basically it used a call to Get-Content that limited the rows to "the first...

Does @f1 ever have a character in it that would be considered invalid in a Windows file name?

Do you know what I mean when I say add calls to "RAISERROR...