CREATEprocJMO_NOD_Self( @k_nod_namechar(65) ) as begin Select nod_name, nod_ckpt, nod_boot Fromjmo_nod Where nod_name=@k_nod_name Orderby nod_name end GO GRANTEXECUTEON[dbo].[JMO_NOD_Self]TO[emadmin] GRANTEXECUTEON[dbo].[JMO_NOD_Self]TO[jmoadmin] GRANTEXECUTEON[dbo].[JMO_NOD_Self]TO[uniadmin] GO