sp_mda

The server must define a stored procedure, sp_mda, to indicate whether or not it supports the ct_send_data routine sending only text or image data without a SQL command. sp_mda is called only if the CS_SENDDATA_NOCMD connection property is set prior to logging in to the server.

If the server can receive text or image data without a SQL command, sp_mda returns:

Parameter

Value

mdinfo

“SENDDATA_NOCMD”

querytype

2

query

senddata no cmd

NoteAdaptive Server cannot receive image or text data without a SQL command.