Query Analyser is not reporting the truncation error for this statement!

 insert tblDbUsageAudit (DbName,nt_username,program_name,loginame,login_time,net_address)

  select p.program_name as program_name,d.name as DbName,p.nt_username as nt_username

   ,p.loginame as loginame,p.login_time as login_time,p.net_address as net_address

  from master..sysprocesses p,master..sysdatabases d where

The SP is only performing insert and update statements and is exactly the same when run in Query Analyzer.

If it was a true truncation error would I not get...