1 Reply Latest reply on Apr 27, 2016 2:11 AM by elizabethcombrink

    Prefix to use in Reseed Script

    dunnsu Apprentice

      Hello -

       

      Regarding the script to reseed tickets...

       

      (example) 

      use [DATABASE]

      DBCC CHECKIDENT ('im_incident', RESEED, 100999)

      DBCC CHECKIDENT ('rm_request', RESEED, 200999)

      DBCC CHECKIDENT ('pr_problem', RESEED, 300999)

      DBCC CHECKIDENT ('cm_change', RESEED, 400999)

       

      What is the logic behind the prefixes im, rm, pr and cm? 

      I created a new module called Project Management and I need to seed the tickets.  Not sure if I should use the prefix 'pm' or something entirely different. 

       

      Thanks,

      Susan