I don't think you will be able to do this link. From SQL Sever you can create a linked server to Oracle; but, from Oracle you will probably need...

looked like a clever solution, so I tried it. where do you propose this be run?

are you working in the GUI (Management Studio) or through an application (like something built in Visual Studio)? Many, most, almost ALL of my problems went away when I...

Thank you Mark. That's great information. I was able to test the MS OLE DB today and it works exactly as you state. It simply does NOT...

I opened a TAR with Oracle and they act like there are no problems (which anybody who uses Google knows is not true), so they are playing a dance with...

You can write a query against the catalog tables (tab, in this example) that builds an SQL script to do the updates. You have to parse the information you...

Could you please tell me exactly how you are creating your OLE-DB data source?

Thank you.

Nice article and with SQL Server and Oracle, it comes back into focus every couple of years. I am experiencing a problem today that is supposed to be with...

I just wanted to say thank you for having contributed to this thread almost 18 months ago. I am now in another environment where I am the Oracle DBA...

most of the posts here on the subject apply to 2003, not necessarily 2000.  I would reference the link to the MSDN document for the conclusive answer.  I think the...

this is a joke, right?  lol

hasn't the "trainee developer" answered this one?  I wonder if he's training to be a developer, or if he develops trainees?

Have a great weekend!  I'm going...

sometimes you get quick answers here, sometimes you don't.

You are obviously stuck... and nobody has responded.  Replication isn't trivial, and 2005 replication is so new, and different, that it's hard...

update #temp2 set col3 =

(select col3 from #temp1

where #temp1.col1 = #temp2.col1)

go

Here is a complete scenario you can test in QA:

drop table #temp1

go

create table #temp1

(col1 char(2), col2 char(2), col3 char(2))

go

insert into...

log shipping should be fine.  That would be my first thought.  at my current client we quickly gave up on log shipping and went to a snapshot... which locked the...

My wife, twenty years younger than me, got off at 11 last night, and gets off at 11 tonight... so I was and hopefully WILL be doing the same thing...