I got you, i see that now. This brings back my original point, as this is exactly how i created the procedure. I know you cant use text variables as...

p.s. this is is not a limitation of Cold Fusion. SQL doesn't accept a text field as large as my xml packets in a stored procedure call. I really don't...

Thanks for your input, but this wont work for me. you are sending a varchar xml packet to your stored procedure, of no more than 8000 chars. My xml packets...

This is probably not your problem, but just in case; I have many times run into an issue where my folder or files are shared with the right authentication, but...

Log shipping or replication would be better. But if you must do it this way, the reason this is happening is because the db is still in use.

you can...

What you are saying to do in asp is what i am trying to do the equivelant of in cold fusion. Our desktop application creates an html form and submits...

Yes, much bigger than varchar(8000). I can work with the xml packet with no issues. the abbreviated look at how i do this is as follows:

EXEC sp_xml_preparedocument @sqdoc OUTPUT, '<cfoutput>#xmlQuestions2#</cfoutput>'

The...

I'm running an active/passive win2k3 SQL cluster with sp3a and have also had no issues. It works like a champe