Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Setting the initial Issue Number

web-app

Is there a way to set the initial value for the Issue number to something other than 1? We are in the process of rolling Gemini out to replace our previous tracking system, and rather than having to deal with the possibility of clients contacting us about old tasks that have the same number as a new one in Gemini, I'd like to set the start value to something sufficiently high that I doo not have to worry about possible duplications (e.g. 95000).

Sean
· 1
Sean
Replies (2)
helpful
0
not helpful

Sure, you can do this in SQL:

DBCC CHECKIDENT('gemini_issues', RESEED, 24999)
will start the issues from 25000.
See: http://sqlserver2000.databases.aspfaq.com/can-i-start-identity-values-at-a-new-seed.html


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Thanks! Worked like a charm!


Sean
· 1
Sean