[droguerman]

Código SQL [-]
CREATE procedure sk_empleados (
   @no_empleado float                /* numero de empleado */
) as
begin
   set nocount on
   set concat_null_yields_null off
   set transaction isolation level read uncommitted
set ansi_nulls on
set ansi_warnings on
   select prettyname as nombre,cb_fec_nac as fecha_nacimiento
   from [srv-tress].tresssenda.dbo.colabora
   where cb_codigo = @no_empleado
set ansi_nulls off
set ansi_warnings off

end
GO

o mejor aun al ejecutar:

Código SQL [-]
set ansi_nulls on
set ansi_warnings on
exec empleados 1.5;
set ansi_nulls off
set ansi_warnings off