As for the future guys reading this thread... The process was fairly smoothly, as originally expected.

Preparation in advance was to taking servers to the same SQL patch level and installing...

This is an old thread, but I'm sure many guys still suffer the dual Oracle client installation.

I managed to install both R2 versions of the Oracle Client without one installation...

Nice and handy script!

So far I simply used part of a New_Id() as a password, but having more complex scenarios is better.

Thanks!

I finally was able to figure out what was happening.

The 32-bit Ora Client sets up the default settings to UTF8 while the standard Ora 64-bit client sets it up with...

Set it to TRUE (the default value). That way would be supposed to work in the same way in the server as works on the workstation.

When I originally arrived to my current work encoutered most web apps using the SA account. But that was not the scary thing...

We had a ton of users querying the...

Hi Steve,

The drives are tipically available on both Windows and SQL Server, however, when it becomes unavailable that's just inside SQL. If you login using the service account the shares...

@@Error doesn't catch unsexistent objects or missing permissions, all those kind of things tipically happening outside any query. It only catches error inside the queries, as let say, datatype overflow...

I still haven't found a solution for this. If anyone have solved this please let me know.

What I did is a dirty trick that executes a batch file every hour...

Sure. The problem is that the drive letter is there. However, is being reported with Unavailable status and cannot read anything from there until I remap and thus, the status...

Beware that this is an unsupported feature from MS.

The results may be much different if you use a complex query to get the string. Happened to me once and it's...

Forget my question. I didn't remembered that I changed the default Data location when installing.

I corrected the script to that path and all worked ok.

Regards

My guess is too that cursors are really bad, and responsibles of the slowness in this case. I'll keep in removing them and let you know in case of something...

Hi Ninja!

Dropped the execution plans, no significant change (about 1 second)

The exec plans are these (wow this thing generated a big one, not sure if are going to be...

Hi Colin

I didn't menctioned it, but already tried installing 2187 with no changes 🙁

I guess the focus is not comparing dbs (the time compared in his db against mine), but...