I am experiencing a problem , we have a procedure which inserts around 16000 records. It takes only 1min 15 secs in SQL 7.0, but the same procedure is taking 4 mins 50 sec in SQL 2000.
Can anybody suggest any solution for this?
I tried to insert 10000 in Pubs database , in SQL 7.0 it took only 15 secs while in 2000 1 min 10 secs!!!!!