somehow I think its on my end in my cursor. Not sure why. If I run the proc manually on a lot of files it is very quick. I think I could avoid the cursor by doing it set based to execute but i am unsure if this will make it faster...
Michael B
Data Architect
MCT, MCITP(SQL DBA 2005/2008),MCTS, MCP,MCDBA