Best Strategy: SP vs DTS in a file importation process

  • It's worth noting that ( I was told at a sql technet nmeeting ) that the sp_oa procs/processes are not thread safe and can cause memory leaks. On a multi proc box they may cause you some grief - which seems to be what's happening.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply