Hi,

I can not use Import and Export Wizard.I have to do it through job.Job will run daily basis and if data is not same then It will make them same.

so...

One more thing If both table are not having same data then how will I make both tablles in sync ie same data in both table

but both the tables are in different database.how can i compare

Thanks but Please tell me syntax of both backup and restore

Hi,

It takes hardly 1 milli second without transaction....but with trasaction database gets hanged up

yes I want to move data into my BCP file and delete it from table

so that I can save space in my database...for furthur use ,I can copy those files...

Hi Gail Shaw,

Thanks for ur reply but can u also tell me code .I am new to database

Thanks

Hi ALZDBA,

Thanks for your reply..Can you please tell me how to create job when I just

want to move few Tables/Views to another location...Not whole db...

Please help...