WHO *created* this part and WHEN did they do it?

WHO *created* this part and WHEN did they do it?

Unfortunately, the PART table in the visual database doesn’t record when a part is created nor does it record who created it.  You can get around this by adding 2 fields to the PART table that will capture who created the part and when they did it.

The following script will add the 2 fields (zCREATE_DATE and zCREATE_USER_ID) to the PART table of the visual database.  It will also set the default values that will automatically record the required information. (Please note that this is for SQLserver)

As always, please run any scripts on a copy of your database and validate it before implementing on your production database

UPDATE: Check out what you can do track when a part is modified here

Copyright 2019 visualnuggets © All Rights Reserved