thanks Deepak but i m getting a error on running ur query that

"Server 'asitcpu738' is not configured for RPC."

Can u help ? Thanks in advance.

I shrink my bith .mdf file and .ldf file but the .ldf file size increased tremendously from 7 gb to 20 gb. althoug the mdf file went from...

i had taken relevant data to another server and than deleted those data from my server because the size in my server was less. but the size of mdf file...

i can not debug on the machine ..i had made a exe and which didn't run and didn't show any error...pervasive sql 7 server and client are installed on two...

Thank u all for ur suggestions. I have made a single ssis package and a single job and been able to tranfer data.

I have been able to create a ssis package to transfer data from one server to another by scheduling a job and deleting the data under the job itself. So...

If u have read my previous message i had asked to suggest best way to solve the problem ..GOT the word meaning "SUGGEST" not do my work ..i...

I have heard of ssis packages but how to conditionally pull data and delete after confirming data has been inserted in centralised server.