Hi Gaz ... where exactly would I find that?

Thank you for you response. I've never used Profiler before. Are you referring to SQL Profiler? The front end program is installed. Would Profiler still be...

Hi Gaz,

It is a datetime datatype. It has a getdate() default set on the column in the design of the table.

This the Personnel table:

Column NameData TypeAllow Nulls

pk_PersGUIDuniqueidentifierUnchecked

sIDNumbernvarchar(13)Checked

sFirstNamenvarchar(30)Unchecked

sSurnamenvarchar(30)Unchecked

uiRegionuniqueidentifierUnchecked

uiGenderuniqueidentifierUnchecked

dDOBdatetimeChecked

uiDisabilityuniqueidentifierUnchecked

bIDCheckedbitUnchecked

uiRaceuniqueidentifierUnchecked

bPreEmployMedicalbitUnchecked

uiEmpStatusuniqueidentifierUnchecked

uiPersTypeuniqueidentifierChecked

bIncompleteIDbitChecked

RowVersiondatetimeChecked

iPersonnelIDintChecked

sContactNumvarchar(30)Checked

uiEduGUIDuniqueidentifierChecked

Unfortunately the program...