Executing system stored proc from vb.net app

[Guest]

I am trying to run a system stored procedure (SP_DETACH_DB) from vb.net
application. I am getting the following error

SP_DETACH_DB not allowed within multi-statement transaction.

How can I fix this? Thanx

 

[Xavier Pacheco]

Either you're running the procedure inside of a transaction or you have
SET IMPLICIT_TRANSACTIONS set to ON.


--
Xavier Pacheco
Xapware Technologies Inc

manage your projects: www.xapware.com/ActiveFocus.htm
the blog: www.xavierpacheco.com/xlog
the book: www.amazon.com/exec/obidos/ASIN/0672324431//xavierpacheco-20