Hello again,

So... before buying 3 servers in order to do the configuration above (1st server - active node for one customer, 2nd server - activer node for the other customer...

Hi,

Thank you very much for your answer. I've found some posts with 3 nodes configuration (2 passive and 1 active) but there were different scenarios and that's why I've asked...

I understand...

Unfortunately, I have a bad feeling about this... Hope it will work...:(

:crying:

So... As far as I understant... it doesn't exist an easy way...

Searching on the web, I've found the article you've mentioned. But why won't it work?

This guy says it's ok...

...

Thank you all very much for your helpful answers.

Hi,

I've had the same problem a year ago when a man from my team was running many reports on the production database and there were a lot of problems because...

Hello again,

Thank you very much for your responses. It's obvious that's not a solution and thank you very much for pointing that.

The reason for this tempDB "clean" is because...

Hi again,

I've just found something...

The script should be something like:

cluster /cluster:cluster-name group "group name"/offline

cluster /cluster:cluster-name group "group name"/online

That's to be done in order to "restart" sqlserver service on the same...

About this subject ...:-)

I know a clear example regarding your question. The programmers don't have always good knowledge regarding the best possible DB structure behind the application, or the SQL...

Hello there,

Is there any configuration (mirroring, clustering) set on your server?

I suppose you have on your server an antivirus. Have you checked its process or if there are excluded/included the...

Hello,

I've found the problem.

I've checked for the cluster MSDTC the Network DTC Acces with both "allow inbound" and "allow outbound" checkboxes.

Many thanks

Thank you for highlighting the problems in the trigger code.

Assuming all the problems are solved, regarding the start-issue, can anyone help me with another suggestion?

Hello,

You need to change your script from:

INSERT INTO docsadm.shellorganisation (disabled) VALUES ('y');

WHERE (((docsadm.shellorganisation.org_name) like 'do not use%'));

to something like this:

Insert into docsadm.shellorganisation (disabled)

select 'y' -- what columns do you...

Hello,

We knew about that option, our trigger looks like that:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER Trigger [dbo].[TRG_Loc_Status_Bol] on [dbo].[LV_StockContainer]

FOR update, delete, insert

AS

BEGIN

SET XACT_ABORT ON

DECLARE @loc_code varchar(13)

--Unblocklocation

SET @loc_code=(SELECT lbc.bol from...

Because on the production db the compatibility level is 80, I have run on master database (90) the query below that does almost what I wanted...

SELECT

sql.dbid

sql.text

max(s.last_execution_time)[LastExecDate],

sql.objectid [ObjectId],

count(*) [Total]

FROM...