I would recommend you to read this

do you have any indexes with IGNORE_DUP_KEY  option in it?

Not implications on reading but on Updates,Inserts and triggers abilities they do have impact because are supposed to guarantee data integrity!

I don't think that is correct

You can check that the Trigger perform on ALL AFFECTED ROWS with

tblName.pk = I.pk

(That is Joining the Inserted Table with the Destination so...

The problem with the built in ftp client is that it CAN'T handle Passive FTP which sometimes is required!  

I am assuming you just want to limit the amount of rows deleted in one transaction:

create trigger tD_U_BenefitType on U_BenefitType for

DELETE as

/* MMC Builtin Sun Feb 25 11:12:06 2003...

if you use WSXXX\Uname you are NOT Logged in the DOMAIN you are logged on your LOCAL systems SQL Server DOESN'T Know the SID of your LOCAL account even if...

what OS  in WS2?

Yep

 TRIGGER TR_U_TblName ON TblName

 FOR UPDATE

IF @@ROWCOUNT = 0

 RETURN

UPDATE TblName

Set LastUpdatedDate = Getdate(), LastUpdatedUser = Current_user

FROM Inserted I

WHERE TblName.Pk = I.PK

Now, there is a catch!  this works if nested triggers are disabled

THE ODBC DSN was created at System level or at user level?

What OS on the Client?

IF You want to reproduce it

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

IF OBJECT_ID('W11_WORKFLOW') IS NOT NULL

DROP TABLE W11_WORKFLOW

IF OBJECT_ID('s00_company_name') IS NOT NULL

DROP TABLE s00_company_name

IF OBJECT_ID('prc_Test') IS NOT NULL

DROP PROCEDURE...

A good start would be to run the MS Best Practices Analyzer and you will get a very detailed info !

Please, don't go to war 

Ok,

Step By Step:

1. MAke sure you can verify the IP Address of your Server !

2. From the Client try to ping it!

3. Install the client network utility on the Client...

Ok,

Let start from the beginin:

1. Check This

2. How are you creating the ODBC Connection?

3. What tool(s) are you using on the client?

My Approach to that problem is to  use 2 separated fields one with date info and another with time info  when inserting / updating data I stripp the unneeded part...