use CURSOR_STATUS

From BOL:

CURSOR_STATUS

A scalar function that allows the caller of a stored procedure to determine whether or not the procedure has returned a cursor and result set for a given...

Write a snippet of code with intentional mistake and let them figure it out

sp_help TABLE_NAME

quote:

---

I am experiencing similar problems. Have all the correct SP's in place, set up the accounts according to spec. and...

quote:

---

Tried xp_stopmail/xp_startmail to see if anything changes?

Andy

---

OK, I'm back in business and we made...

Andy,

I was sending e-mail to myself with full e-mail address, so I know it is valid.

We are able to send e-mail from this server without using xp_sendmail, but our applications...

You can try :

update syscolumns

set length =2000

where id =object_id('your_table')

and name = 'column name'

The problem is - you can get an error message :

"Ad hoc updates to system...

Are you running your query from QA?

If it is a case you should change settings on a menu:

Query-Current Connection Option on Advanced Tab - Maximum Characters per column.

Set...

quote:

---

There is no array construct in SQL, but there is a table datatype, which is similar.

---