Try changing the trigger to be an UPDATE statement that gets executed directly after the BULK INSERT step is complete in the DTS package.  I believe the problem is that...

Congrats Andy!

Having a Baby and a promotion WOW!  My daughter (see pic.) is now 3 1/2 and it is a HUGE change.  I wouldn't change it for the world.

Congrats again...

Depending on your system set-up TRIGGERs might not be the way to go (They can lock the system up and cause performance issues)

Why not Add a 2nd line of code...

Try providing the object database and owner.  The ADO connection may not be robust all the time to automatically go to the right place all the time

Good Luck

I agree with wz700.  I have done this in the past.  You will need to use WITH UPDLOCK (see BOL) though to ensure that the row is being updated properly...

SQL will try and use the ABC1234 sp first.  IF the owner is not qualified SQL tries to 1st run the user.object then (I think) dbo. and then any other...

I didn't get the question right either.  I tested similar to everyone else and made my decision based off what I saw and not the one little note in the...

Note  If object names in the statement string are not fully qualified, the execution plan is not reused.

Direct from BOL on why.....

please follow message thread for this by using the below link:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=114922

Another thing you can review is the db_denydatawriter.  This will allow access to the DB and they won't be able to change anything.

I think you are correct in assuming it is because of the malformed syntax.  I think that SQL is probably getting confused by the 4 different ways you...

You can research xp_readmail from BOL however, I don't think this will work for you.

The SQL server can read mail sent to the SQL server but, I haven't heard of...

If you want the ability to rollback from SQL 2K to SQL 7 make sure that you DON'T use any new features added into SQL 2K, make sure the database...

I know that you can password protect a DTS package.  I know that you can also edit users authentication layers to disallow them from even seeing DTS packages if they...

Is it possible for you to post the code so that we can review it and see what is going on?  Have you looked at the execution plan to see...