Yo escribiré en mi lengua natal. Muchas felicidades en estas fiestas de fin de año 2013. Que hayan pasado una FELIZ NAVIDAD en compañía de sus seres queridos, amigos...

great work man...simply with great potential ..sorry my english...

why dont use a tape backup ?

sql server can export data to excel, access or .txt files via DTS ....

it works for you ?

i've been programmer (VB6, .Net, ASP, using COM+ and WEB SERVICE) and i understood when you make this kind of app (3-layers), app is a "slave" of data repository (DB2,...

i've been programmer (VB6, .Net, ASP, using COM+ and WEB SERVICE) and i understood when you make this kind of app (3-layers), app is a "slave" of data repository (DB2,...

you must use a trigger

CREATE TRIGGER tr_ins_tableA

ON tableA

FOR insert AS

--insert into server B; must be linked

INSERT INTO ServerB.DataBaseB.dbo.tableB

         (col1,

         col2,

         col3,...

         )

         SELECT 

            ins.col1,

            ins.col2,

            ins.col3,...

         FROM inserted ins

Very strange.  I assume that the column 'date' not this defined like so.  But the probable thing is that it has an error in the definition of the value for...

good for start, but if I have more complex dts...may be I can create a job and after execute it from vb.exe with

"sp_start_job @job_name = 'My Job'"

using and ADO connection...