Thanks alo Gail

but where i should write it?

about Writing Truncate only i should open a new quer and write

Truncate Servername.Databasename.dbo.Tablename

in it ?

TRUNCATE is a non-logged operation, so if you are using log shipping or have regular log backups running, it can cause you some issues.

sorry what do you mean by...

i want to remove all rows , then modify my table deign, how can i use Truncate?

Yes,

Yes.

Yes,

Yes.

sorry

the correct name are:

ServerA.Source.dbo.Table1

and ServerB.Destination.dbo.Table2

but what should i do about the modifyng those 2 fileds

thanks

i think i have to use (CAST) for transfering because in Destination the data type of Body is nvarchar(max) and in the Source it is ntext ,

a T_Sql...

Thank you all,

This Trigger works successfully:

alter TRIGGER [TRG993]

ON [dbo].[Source]

AFTER INSERT

AS

BEGIN

SET...

Thank you very much,

would you please help me to write a T_SQL block for transfering data from one table in one data base to another table in another data base?...

Thank you very much,

the Trigger is working ,

but how can i become sure about this Trigger transfer all of my data in Source table in field that its type...

" You'll need to join the inserted table to the source table"

please help me how

and write for me that if i do so may i to transfer data from a...

Thank you for your reply

when i used from (inserted)

this error mesage came:

Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.

but for examination your previouse help i want to write an after Trigger ,please help me.

thanks

yes , i have problem when i want to do this conversin through SQL, because ntext is pointer az i told you it save my data in different places not...