sql - SqlCommand don't throw error for cast e -

i have scheme runs on sql server 2008. don’t exception when execute query .net application.

this example, run next statement. i'm attempting server throw exception:

myquerystringvar = "select cast('test' bit)" dim mysqlcmd new sqlcommand(myquerystringvar, connection)

but executing command don't exception.

if seek query on enterprise manager, on different scheme (i've not access enterprise manager on machine) next error:

select cast('test' bit)

conversion failed when converting varchar value 'test' info type bit.

i'd kindly know if can provide input future investigation.

do know if it's possible set threshold exception level on sql server? if error if less of import exception level don’t exception.

thank maurizio

sql sql-server vb.net ado.net

Three