Help needed with cross-vendor replication mssql->oracle

Have you also checked the oracle-side? (tracing,locks etc)

Happy New Year

Can't tell much without actually seeing it. I had success using orafaq[/url], just be sure you read the forum guide. Do you have a testcase (create table, insert data, select...

Agreed, I grasped that per VM there are 4 core licenses necessary. So you only need 4 no matter the underlying hardware cluster (if you only use 4 virtual cpu's...

There is a command to lock an entire table LOCK TABLE employees IN EXCLUSIVE MODE NOWAIT; , but haven't tried this from MSSQL. Perhaps through openquery.

Not sure why you...

Congrats with the rescue Jason

Getting ready for windows 7 & windows server 2012.

Relearning MSSQL and improving the current monitoring for facts & figures.

make sure you make it a date-datatype instead of a string using cast or convert

Comparing dates with strings is usually a recipe for disaster

Nice that the DTA advisor mentioned a missing index, even learned a new keyword "includes" (any benificial scenario's for include?). A rewritten index made it even better.

I was looking for a random news fact dated 19th of november 2000. Milk Inc is mentioned at the bottom.

DBCC Timewarp: Active Directory returns to 19 november 2000. New singer Linda Merts for the popular belgium pop/dance group. Waar zijn die handjes?:-D

Save the environment and enable free compression in the standard editions.

The hard part is getting there, having the monitoring setup as you would like. Transforming from add-ons to smoothly integrated. Still playing with various nuts and bolts

You run those programs in "windows safe mode"?