Table structure looks fine.

Can you rescript your table generation? It gives some errors on tablenames.

If you want to see the strict org structure, choose inner joins instead of left-joins.

generally the more spindles the better

Although using 16 drives oposed to 3 raises some questions.

Large drivers are generally more modern than smaller ones, and you get extra management with so...

Shooting a bit in the dark: could it be that with ANSI_NULLS ON it will have to join less data (since  = NULL always gives false) and somehow the optimizer...

What machine is it?

Does it has all patches?

Did occur it suddenly? If so any clue what has changed? (network, new machines...)

*is there a special reason why you use WHILE (@@fetch_status <> -1)

instead of WHILE @@FETCH_STATUS = 0 ?

*your cursor can probably be readonly forward_only

*WHILE (@@fetch_status =0)

BEGIN

/*  print @name

  set @sql='update udt_DBA_Server_Jobs set...

That's odd

Have you checked the MSDTC settings on the windows 2003 box?

http://support.microsoft.com/?kbid=899607

Is there any difference in hardware between the windows 2003 box and windows 2000 box?

What are the patch...

The same.

Only when each record will have a recordlength of 100 you can consider nchar

practically nothing, sql server only stores the 100 unicode characters

I fail to grasp the logic

first is looks like min(starttime) max (stoptime)

But how you come to?

Date u_id start_time stop_time

01.01.05 01 08:00 12:00

01.01.05 01 08:00 09:00

01.01.05 01 11:00 12:00

01.01.05 02 08:00...

You're welcome.

1)the where clause checks if there was a change present for the given row

WHERE ISNULL(INSERTED.FIELD1,unplausiblevalue)<>ISNULL(DELETED.FIELD1,unplausiblevalue)

OR

ISNULL(INSERTED.FIELD2,unplausiblevalue)<>ISNULL(DELETED.FIELD2,unplausiblevalue)

... (every column)

2)as far as I know a trigger is always a transaction, so...

CREATE TRIGGER TR_PROJECT_UPDATE ON [dbo].[tblProject]

FOR UPDATE

INSERT INTO [dbo].[tblProject_audit]

(Field1,field2,....)

SELECT

CASE

 ISNULL(INSERTED.FIELD1,unplausiblevalue)=ISNULL(DELETED.FIELD1,unplausiblevalue) THEN unplausiblevalue /*not changed*/

 ELSE DELETED.FIELD1 /*old value*/

END AS FIELD 1

,

CASE

...

FROM INSERTED INNER JOIN DELETED ON INSERTED.PK=DELETED.PK

WHERE ISNULL(INSERTED.FIELD1,unplausiblevalue)<>ISNULL(DELETED.FIELD1,unplausiblevalue)

OR ...

you...

Can you post vstr?

Usually there exists a function Replace in Asp, ...

It also depends on how busy the server is.

Have you applied service pack 3 or higher to your sql server?

Windows 2003 won't let remote computers connect to unpatched sql servers.

I have no clue, recently someone asked the same for warnings.

You can raise a custom error with RAISERROR but the original error will be sent also (I presume).

Does the application...