At work we currently differ the password the application uses to connect to the various servers. (sql authentication at the moment)

dev: login applicationX password applicationTesting

QA: login applicationX password applicationQA

Prod: ...

So...

Can you trace how far the program goes along with sql server using the sql profiler? What was it last statement ?

Have you changed the language of sql server or the default language...

Needs some testing (restoring the backup), a good network connection. (the smallest thing could make the backup corrupt making it a high risk operation)

A mapped (X

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...