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

Accoring to the books online, error 208 = invalid object name

Are you specifying the owner of the stored procedure when executing it?

Like

EXECUTE dbo.USP_TESTING

instead of EXECUTE USP_TESTING (looks for an object...

can you remove the @ at

cmd.Parameters.Add("@login", SqlDbType.NVarChar, 255) ...

I guess ado adds it by itself.

there is a "split" function in the scripts section that is able to split a string in seperate items

A stored procedure could

1) insert the splitted items in a temporary table

2)...

Without affecting the final result -> means the same result at the end  <> the same path used to get the same result.

inner join only red and marbles-> collect all marbles from...