create proc ##p_retMessage
as
  select 'error' as  errors
  raiserror('Сушите весла!',  16 ,  2 )
  raiserror('Cейчас cлонов буду раздавать!!!',  16 ,  2 ) 
GO

var conn = new ActiveXObject('ADODB.Connection');
var cString = 'provider=sqloledb.1;server=localhost;trusted_connection=yes';
conn.Open(cString);
try {
conn.Execute('exec ##p_retMessage');
}
catch(e){
}       
WScript.echo( conn.Errors.Count );
conn.Close();

var conn = new ActiveXObject('ADODB.Connection');
var cString = 'driver={SQL Server};server=localhost;trusted_connection=yes';
conn.Open(cString);
try {
conn.Execute('exec ##p_retMessage');
}
catch(e){
}       
WScript.echo( conn.Errors.Count );
conn.Close();