and that answer was

set rowcount 10

select * from tableA

Was having a Stupid Attack found my answer

Thanks that worked like a charm. I appreciate the input

Thanks for the suggestion

here is my script

alter  procedure JFM_process

as

set nocount on

declare @mySPID int ,

 @myPrint varchar(200)

declare curProcess cursor

for

   select spid from master.dbo.sysprocesses

   where  loginame like...