If you to setup an operator, can you test email by clicking test.

Use Database repl object in DTS.

How about select * from sysfiles, this will show the database physical files and their sizes. You may want to insert the result into a table and format output as...

I guess a triger could do the job and checking for errors after each action.

Or you can check for length and use stuff command.

I would guess the cause is one of the cols from source is not matching the dest. one. I have had this when the data in the row from source...

If you change the DTS version the job will still run the package with the new vesion. I guess the answer with setps run as maybe a better one to...

I've had this error only when I am inserting a data in a field that is smaller the the data size.

Azz.

ou can create your field as nvarchar and save your dates in mm/dd/yyyy format if you are in the UK or dd/mm/yyyy if you are in the USA. You could...

I would use VB services ActiveX component and query the service status and start it if need be.