I have a database with a table that has an Identity column. It has worked fine for months. All of a sudden I get duplicate row errors during inserts (complaining that the Identity column is being duplicated). I ran a dbcc CHECKIDENT command and it returned: "current identity value '1', current column value '74155'." I tried dbcc CHECKDB (and even updated statistics) and it didn't fix. Does anybody know how I might resync the Identity column?
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…