I wonder if the person who set the question could explain his/her thoughts behind the "answer". At least it's got us all thinking about the consequences of both data...

I suppose something that gives you the same results but by a different method - my point was that the conversion to varchar(max) isn't guaranteed to do this.

I don't agree that using the conversion to varchar(max) is suitable... you're going to get truncated data when the data in the text fields is too big. If the...

I'm generally agreeing with all the points above, 2 years for a new software release is too quick, but wouldn't be so bad if it wasn't a server application like...

If you know the details of your SMTP server you can do.  We run lotus notes here, and while we can't connect directly through a client, we have allowed our...

Right - I managed to fix this....

After a few days trying various different options with regards to DCOM, ini.xml files and the shared disks on the cluster - it turned...

We're currently having this problem - only in a clustered envrionment.  I've ran through the usual stuff with the ini.xml file and placed everything on the shared disks, but I...

Try inserting

PRINT @DTSRUNCommand

in the stored procedure, use the output from it to run it manually on the server to see what happens?

Dave

Try using BEGIN transaction at the start of the SP, then check for @@ERROR and @@ROWCOUNT to check for errors.  You can then output/write to a table any errormessages before...

We've been running several servers with this configuration (and someof them in clusters) without any problems... so you should be fine

Dave

As much as I hate to say it - but this is were you need to do some systems analysis.  Even if it's just running some DFD's and doing some...