[rt-users] Re: Altering/Resetting ticket id # - Help!

[seph]

>     I figured it was something like this.. but I've tried altering the
> "Tickets" table and "Transactions" to reflect a ticket number of say
> 10000, thinking the next one would be 10001.
>
>     Doesn't work :( . Next ticket goes back to next in the
> sequence.. The tickets all work once doctored up to 10000, but new
> tickets go back to 5,6,7 etc.
>
>     Im pretty good with SQL but this ones got me scratchin my
> head. Guess Illl have to go debug the CreateTicket function.

no, I'm pretty sure you want to modify the sql *sequence* not the
existing table or CreateTicket.

seph