I agree, please give me some hints , If you have seen memory drops on your SQL servers without any clear reason . I will put service Pack 1 next...

create table #t1 ( bufferdist varchar(80) null, numbuffs int null)

use         numbuffs bigint null 

if you have more than 4Gigs of Ram

Thank you !

I'm concerned only about the speed with this solution , I hope the rowcount should be never bigger than the sysobjects table

Look with the profiler to see the exact SQL command generating the error. Try to do the SQL command  out of the trigger to reproduce the error . This would close at...

Thank you for the work ! It's really helpfull .

Why can not select cast ( '123'+char(160) as int) work ?

Seems to be a difference of coding between this 2 functions. ISNUMERIC...

Please explain this one :

12/16/2005 2:49:21 PM:  Ascii code : 0   isnumeric : 0

 12/16/2005 2:49:21 PM:  Ascii code : 1   isnumeric : 0

 12/16/2005 2:49:21 PM:  Ascii code : 2  ...

You should use the dictionary of the database to see the structure of the table. Then based on this make a dinamic sql to take only one field from every...