Ram

I understand your point. My own mother language is Chinese. However if I live in US and I have respect this country official language so I have to...

I think you better get a book about SSIS. It is totally different from DTS. Some of the tasks are no longer used.

The error log said Step 'DTSStep_DTSDataPumpTask_5' failed not Step 'DTSStep_DTSDataPumpTask_6' and it failed due to network problem.

Was the data in the client table different when the bcp failed? The error message seemed to tell me the length of one column in the client table was...

In SQL Server 2005, DTS is changed to SSIS which you would find under Business Intelligence development studio.

In your procedure it would not show bcp failed because you used xp_cmdshell. It just checked if xp_cmdshell executed, then it returned a successful status.

You need to create an login account in Server A and the same login in Server B. When you create the linked server between A and B, you...

declare @RECORDCNT int

declare @TABLE char(100)

declare @cmd Nvarchar(100)

-- Set the table to be used

set @TABLE = '[ORDERS]'

-- Build the dynamic T-SQL command

SET @CMD = 'select @RECORDCNT=count(*) from ' + @TABLE

-- Call...

As Steve said before, DO NOT USE TRIGGER !!!!!

It is getting more and more complicated working for corporation. Long time ago I made a choice not to pursue management because I do not like company politics. ...

I was pushed to resign myself because my manager and I did not get along. One example he wanted to use trigger to insert data into the one main...

One thing about US English and UK English is spelling. There are some words that spell different, eg in US we spell 'color', in UK 'colour'.

I don't know which...

Steve,

I always use SYSOBJECT but you suggested to use information_schema.tables. What's wrong with using SYSOBJECT?

Maybe I really need to beef up my DBA skills, I guess being a part...

You can also do a RTRIM(LTRIM(.....)), this will eliminate any white space.

I am still not very sure what you want to store because you said something about syntax error.

I had created a error table before to store the errors of some...