* are your insert and update 2 different actions/inserts. Could it be that one connections uses the default dateformat (us_english m/d/y)

the only things that really helps is having the client updating...

I would start with backup/restore

Than security

Then see other topics above.

I didn't have the need yet to use DTS packages or SQLMail.

*misread*

Excuse me, my mind is a bit troubled.

The scripts was well done

Can you post an example of wanted output? Do you mean like a roster?

Squadrons

        list of divisions

                   list of...

This is because the order of execution. JOINS before where, where before having...

select Label,Color,SampleLabel

from TblSample

LEFT OUTER JOIN VWClosedSampleQuotaView X

 ON TblSample.Label = X.SampleLabel

gives

Label Color SampleLabel

Alice Red Alice

Bob Red Bob

Cathy Red Cathy

David Blue David

Ellen Blue Ellen

Fred Blue Fred

Gale Yellow Gale

Harold Yellow Harold

Irene Yellow Irene

Apply where clause SampleLabel-> no records...

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