Erland Sommarskog (10/29/2014)
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! 😉What is important is that there must be no space. That is, it should be -T272.
No, -T272 doesn't work. It must be -t272. Lower "t" only for trace flag 272. I've experienced this on two instances running on clustered environments (AlwaysOn and Shared storage).
If you don't believe me, then double check it here.
http://sqlblog.com/blogs/kalen_delaney/archive/2014/06/17/lost-identity.aspx
Igor Micev,My blog: www.igormicev.com