This would fail if you have only one item in the @array var without a trailing comma e.g:

DECLARE @array VARCHAR(max)

SET @array = '1'

SELECT item FROM strToTable(@array,',')

This would break the...

The scheduled job runs OK. The problem occurs when executing the DTS both by manual and automated methods. Everything is fine until the cursor within the stored procedure...

I'm doing something similar to this but have recently experienced problems. See my forum entry: http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=9937

It use to work but now the DTS package stops as soon...

Check out my problem:

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=9937

Is there anyway to get the cursor to continue once xp_sendmail has encountered an invalid email account?