russc-993845 (10/29/2014)
Whatever luck you want to call it, it has worked for me through at least 6 versions of SQL. Judging by the number of posts across the net from others complaining about the same issue, I'm not the only lucky one! 😉
There is more than one situation where people has used improper solutions, which has seemed to work, but where there never were any guarantees.
Yes, I meant the startup option - sorry I wasn't clear. There are multiple posts from people stating the upper case T doesn't work - though some said it did. I haven't tested it yet though I will be this weekend.
What is important is that there must be no space. That is, it should be -T272.
There is all reason to consider implementing solution where have control over how the numbers are generated. That 1000-id gap was an accident that was waiting to happen all along the way.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]