sorry

if i want to write this Query as Trigger for examinaton , what should i do?

the Schema of Destination table is :

id int

title nvarchar (250)

body ...

thank you very much for your reply

the Schema of source table is :

id int

title ...

thank you for your reply

i want to get data with (ntext) type from one Database and input them in a another Database with (navarchar) type and for is purpose i...

hello,

Thanks alot,

i Found it.

please help me for configuring Web Service Task for Exporting Sharepoint list data to SQL Server 2005, please introduce me a Step by Step manual.

and another...

thank you for your reply'

but from where i have to configure it, where is the "Web Service Task"? is it in management studio? or .... i can not...

thank you very much for your kind,

i will try to write my question defenitly,

i have a site with sharepoint(2003), the users enter data to excel form,as documents library, in it,...

PLEASE help me

and tell me how i should use SSIS for saving my data from Share point to SQL server 2005.

thanks alot

Thank you very much

but another error occured

i wrote Trigger and i create the primary keys

but every time (when i add a new record to DB1.Table1) i have 2...

What should i do about the primary keys:

in DB1.Table_1 , "Filenumber" is Primary key , but

i want to have "Code" and "Filenumber" (both of them) be the primary key...