I have a SP that I can run from QA, and command line with no issue. But for some reason it hangs when it's called from the APP. At first we thought it was a cache issue so I put WITH RECOMPILE in the SP. so we started a trace in it. We found the part that was having the issue. The issue is at a Link...

Hi all, Im having two tables with 1 crores of record each. I want to avoid its duplication.But when im giving the query in query analyser for that.Its giving an error that,connection broken.Or sometimes in main window its giving time expired. What shoul i do for this. Kindly help me. Thank You. Jeen

As suggested by Dinakar take help from BOL on import/export wizard, also take a look at http://www.sqlteam.com/article/using-select-to-insert-records , http://blog.sqlauthority.com/2007/08/15/sql-server-insert-data-from-one-table-to-another-table-insert-into-select-select-into-table/ and http://www.xlinesoft...