A trigger is an in-transaction-procedure. (has to be performed in the same transaction as the object-action it is fired from)

This means that when your trigger fails, your whole transaction has...

That's what I like about this site and the QOD's.

Sometimes things are kept in mind because of an "Aha-Erlebnis"

Because your column is defined datetime ( Correct datatyping ! &nbsp it is best to order on the...

maybe this helps :  ( and the comments ! )

http://www.sqlservercentral.com/columnists/awarren/worstpracticesobjectsnotownedbydbo.asp

http://www.sqlservercentral.com/columnists/chedgate/worstpracticenotqualifyingobjectswiththeowner.asp

http://www.sqlservercentral.com/columnists/sjones/istheschemastillneeded.asp

IMO it is more important that we can see who or what disabled it. and that it is meanth to stay disabled.

I don't know if this is what you want.

Keep in mind this is using xp_cmdshell !! (you don't want to open it for...

I've just replied to your http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=152411 

Welcome to SQLServer's community.

If you have saved the DTS-package, then you can rightclick on it and there is an option "schedule job".

Just verify...

If you use the propre sp, things whill work fine.

This is because these procs also tell the running sqlagent to refresh its job-data.

I use it all the time when e.g....

with sql2k sp3 one can have Cross DB Ownership Chaining.

If I'm correct, this way you can avoid to have to authorize sp-users to the other db unless you encounter...

I have done some testing now.

The problem is that the select which is done to perform then insert, is performed before the actual insert is being done.

This way your new...

Regarding the DRI problem :

Do you upload an new set of parent data with as well the old as some new data ?

if yes :Why not only bulk-instert only the...

IF [is your sp3 on a multi-processor box ? ] = 1

begin

    if [Is it a sql2k standard edition ? ] = 1

       begin

            if [did you apply the...

maybe just perform the select so you can detect and verify the duplicates

How about avoiding the udf and using this select ?

SELECT rs.EmployeeID, rs.School, w.WorkDate

, isnull((select max([counter]) + 1

FROM SchoolServices

WHERE EmployeeID = rs.EmployeeID AND School = rs.School AND ServiceDate = w.WorkDate...