I did try the query on my Windows 7 workstation running the Developer's Edition and got the following results:

namedescriptionfile_versionproduct_version

C:\Program Files\Common Files\System\Ole DB\oledb32.dllNULL6.1:7600.163856.1:7600.16385

C:\Program Files\Common Files\System\Ole DB\OLEDB32R.DLLOLE DB Core Services Resources6.1:7600.163856.1:7600.16385

C:\Program Files\Common...

Gift Peddie (12/27/2010)

---

Then it must be edition related or an upgrade because there is MSDAORA in the list of providers in my developer editions for both 2005 and 2008. ...

Gift Peddie (12/26/2010)

---

If all you need is the Linked server then use the Linked server component in SQL Server 2008 under server objects in SMS and use the predefined Oracle...

I also agree that there are valid uses for shrink but it should be used judiciously and with extreme caution. In most production environments I see little need for...

Jennifer Levy (12/3/2010)

---

My next door neighbor in cube-land has no clue what a library voice is, carries on conversations over the cube walls no matter how many times she's been...

Don't feel that you're alone in that practice!!:-P

I'm a rather noisy office environment due to sitting near the help desk with the accompanying phone conversations and ringing phones. Therefore, I find solace in listening to classical...

I've had an opportunity to work some more on this and the situation is a bit more complex than I originally thought. Therefore, the following code has been revised:

DECLARE...

OK, I finally had a chance to review the suggested code. To get it to work, I had to make a few modifications. I'm not sure that it's...

Thanks, Wayne. It will be a few days until I get to try it again. I'm off to a wee bit of a vacation to my brother's wedding....

Thanks for your...

Hugo Kornelis (6/28/2010)

---

Your confusion comes from posters who claim they "post to get their point". That refers to the fact that every post made also awards a point. Not in...

cfradenburg (6/28/2010)

---

Right. However, I just read through 7 pages of mostly repeated posts about what the correct answer is seeing if a mod had already addressed anything. At...

As per your suggestion, Lowell, I'm posting the final solution in a manner that can be cut and pasted into SSMS. While your solution solved the majority of the...

Thanks for your help, Lowell. I was concerned about putting in too much information that was not relevant to the issue, so I attempted to narrow it down a...