Difficult topic as modern tapedrives can take a lot of feed.

Have a look at the recent article regarding sql server jobs[/url]

Why in sharepoint and not a regular fileserver?

Haypp Christmas,

From job perspective it is probably a benefit knowing more than 1 database. SQL Server is easier to administer as it comes with various tools to do so (and...

Good point. Virtualization has many benefits: easy migration, lab testing, flexible in hardware resource, not so dependent on hardware-age

My mayor gripe with virtualization is the licensing model some software vendors...

Thanks for sharing the workaround

I've found an older reference of the problem. You might check the creation script on mixed case.

reference

Otherwise try to setup a trace on the oracleside to see what sql server...

I'm not familiar with crossdatabaseplatform replication. What ora-... error do you get?

Surely there is the need for some thinking time. Many hours of sleep lost when the brain decides to rehearse a memorable problem instead of snoozing.

Could you use code tags?

AND"+

"z.usernameman

concatenates to andz.usernameman which is invalid

Trying to generate dynamic sql?

Also have a look at Quest for SSC alike oracle forums

A point for keeping the modified always filled in >=created date is that your index search on "created or modified within the last 24 hours" works faster (only checking on...

Also the oracleversion of the backend is important as msdaora is discontinued, you better use the oracle-driver from oracle (from oracle 10 on)

impdp/expdp doesn't exist in oracle 9? Imp/exp does

I've converted the right-join in a left join (as they are rewritable),didn't feel like reordening my whole query.

Easiest is to remember (+) means: if not found add a null...