<div>
If this is the case, then it's an issue for the GoDaddy support. <br />
<br />
Just run a DBCC CHECDB to test the database integrity.
</div>


<div>
Msg 7983, Level 14, State 36, Line 2<br />
User 'kenkenken' does not have permission to run DBCC checkdb for database 'kenkenken'.
</div>


<div>
Use [kenkenken] DBCC CheckDB
</div>


<div>
Then contact the support.. it maybe database or index corruption.
</div>


<div>
id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;description &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; timestamp<br />
13707 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Borrowed from BO Starcity &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2014-08-27 00:00:00.000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2014-11-24 12:07:58.237<br />
14646 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Borrowed from BO Starcity &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2014-08-27 00:00:00.000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2014-11-24 12:07:58.237<br />
15546 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Borrowed from BO Starcity &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2014-08-27 00:00:00.000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2014-11-24 12:07:58.237<br />
15809 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Borrowed from BO Starcity &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2014-08-27 00:00:00.000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2014-11-24 12:07:58.237
</div>


<div>
I suspect you had a JOIN on the INSERT that caused additional rows to be generated. &nbsp;But on the extremely limited info so far, there's no way to really know what happened.
</div>


<div>
<blockquote>
id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; description &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;timestamp<br />
&nbsp;13707 &nbsp; &nbsp; &nbsp;Borrowed from BO Starcity &nbsp; &nbsp; &nbsp;2014-08-27 00:00:00.000 &nbsp; &nbsp; &nbsp;2014-11-24 12:07:58.237<br />
&nbsp;14646 &nbsp; &nbsp; &nbsp;Borrowed from BO Starcity &nbsp; &nbsp; &nbsp;2014-08-27 00:00:00.000 &nbsp; &nbsp; &nbsp;2014-11-24 12:07:58.237<br />
&nbsp;15546 &nbsp; &nbsp; &nbsp;Borrowed from BO Starcity &nbsp; &nbsp; &nbsp;2014-08-27 00:00:00.000 &nbsp; &nbsp; &nbsp;2014-11-24 12:07:58.237<br />
&nbsp;15809 &nbsp; &nbsp; &nbsp;Borrowed from BO Starcity &nbsp; &nbsp; &nbsp;2014-08-27 00:00:00.000 &nbsp; &nbsp; &nbsp;2014-11-24 12:07:58.237 
</blockquote>
How did you inserted these rows?<br />
Those are all columns in the table?
</div>


<div>
Yes they are columns in the table. &nbsp;There is a possibility in my code that it is adding extra records. &nbsp;Not sure what is going on? I am planning to review the code.
</div>


<div>
How can I delete all other identical records except with the lowest ID<br />
<br />
Can you suggest a SQL query?
</div>


<div>
<div class="content wysiwyg-content">
Is it possible at all that godaddy server did this? &nbsp;I cannot think of any queries I have run to make this possible.<br />
<br />
Please please help!!
</div>
</div>


Is it possible at all that godaddy server did this?  I cannot think of any queries I have run to make this possible.

Please please help!!

I am using a shared MS SQL server on Godaddy.  I noticed this morning that my each record was duplicated 5 times

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.