if you want to increase the chance that sql server uses an index; only select the necessary fields instead of select *.

Does the sql server account have permissions to write on the share?

Autostart MSDTC is enabled on both sql servers?

Unsure about this but there could be a problem when msdtc is started after sql server.

Same servicepacks.. SP1,SP2,SP3,SP3a,SP4...?

Nt servicepack SP6, SP6a?

Any firewall in...

There seem to be some indendations (whitespace?), is the column defined as char?

What is the patch level of the ado component (mdac 2.8?)

for step 3, have you also tried sqlplus to connect to the database from your cluster?

I have no experience for clusters but it could be required that both hosts have to...

Happy to help 🙂

The main relinking happens in fcRefreshlinks.

strNewConnect = the new link/connection to your tables.

findConnect(strDatabase, tdf.Name, strOldConnect)

is a function to get the updated connection.

see http://www.connectionstrings.com/ for possible connection strings

You could...

NT-machines... hmm... which servicepack and which sql server version?

Do the tables have a primary key?

Both servers have MSDTC service running?

Have you rebooted the machines?

=0 is false

<>0 is true

Is one of the servers OS windows 2003?

http://support.microsoft.com/default.aspx/kb/839279?

sequence:

shopping cart : adding things that are in promotion and minimum profit 5 $

insert into shopping_cart

from promotion

inner join articles on articles.promotionid=promotion.id and promotion.discount>5$

->before adding it filters all promotions that has...

my select was still bugyy

Thanks for the solution!

In the second query you can replace

WHERE  A.Application_Key In (Select Application_Key From peoplefirst_datawarehouse.dbo.application    

Where valid_application_flag = 'Y')

WHERE  EXISTS (Select Application_Key From peoplefirst_datawarehouse.dbo.application    

Where valid_application_flag...

What is the patch level of the sql server?

http://www.fogcreek.com/FogBugz/KB/dbsetup/FullTextSearch.html

discusses how to setup FTS

1) Have you installed the oracle client on the server?

2) Have you rebooted the server afterwards?

3) Can you connect to the linked server by using the Oracle Tools on the...

Can you use the sql profiler to trace your stored procedure?