thanx Rob for your help ..... but it is still not working when i execute it i get the message

execute SP_CK_EVENTDATE ('emp');

Server: Msg 170, Level 15, State 1, Line 1

Line...