I posted a link in my post.

Here is it again. Click this link http://technet.microsoft.com/en-us/library/ms143690(SQL.90).aspx

You may have to reinstall COM+ service and then try SQL Server install.

Here is some info. Let us know how it goes.

How to: Work Around COM+ System Configuration Check Failure...

Try these links

Connect to SQL Server from Oracle

Connect to SQL Server from Oracle with screenshots

I am not an Oracle guy but I read this article few months back.

Hello Arpan,

Did you check the permissions for Public role? If the public role has the ability to update records, then that would explain why the specific user is able to...

Wayne, Cool script.

BUT in the final Select statement, did you mean to use column names instead of the variables?

-- now, get the data for each column

SELECT [ID] = ROW_NUMBER()...

That is correct.

SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition.

You still have to choose...

GP/All,

Apologze for the confusion. The issue that Adam is having really doesnt involve Oracle 9. My post may have led us down the wrond path.

I just was stating on something...

Hello GP,

Thanks for pointing this out. This may be an issue for sure.

But I definitely have worked in an environment where we have used 10g client against Oracle 9, but...

Not an Oracle expert. But it probably will work.

I have used 10g clients against Oracle 9 without any issues.

You have the correct link to download Oracle 11 client.

I dont think Oracle lite will work. You will need to download Oracle client. I have provided a link to download Oracle 10G client.

BUT like Bru has suggested, first you...

Mark, Good information. Thanks

what are you trying to accomplish? you can backup the database using the backup commands.

Is the SQL Server service running? You can check Windows Services applet.

One more thing, if you ever decide to physically move the .mdf file to a different larger drive, that can be done as well but that will definitely require a...

No. It doesnt require a downtime. Anyways, always backup the database.