Table has corruption. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Table has corruption.

Author

Topic

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2014-05-10 : 12:06:31

I have a single table in my database that is causing me some issue.

Rebuilt indexes, reoganized, dbcc, etc and everything goes through except


update statistics  [dbo].[mytable] with fullscan

It works fine leaving the fullscan portion off.

The erros I have received thus far ar

paraphrased
"An internal error has occured please disregard and results if any"

"An inconsistency was detected during an internal operation in database 'tempdb'(ID:2) on page (1:1167). Please contact technical support. Reference number 5."

Any idea's? I am thinking it's probably best to simply recreate the table.

Success is 10% Intelligence, 70% Determination, and 22% Stupidity.
\_/ _/ _/\_/ _/\_/ _/ _/- 881

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2014-05-10 : 18:36:47

I solved by just recreating the table.

1. Renamed table to mytableold
2. Select *
Into mytable
From mytableold
3. Setup constraints, defaults, index's, etc

Wasn't my favorite method, but it appears to work now.

Success is 10% Intelligence, 70% Determination, and 22% Stupidity.
\_/ _/ _/\_/ _/\_/ _/ _/- 881

prett
Posting Yak Master

212 Posts

Posted - 2014-05-14 : 01:27:44

Nice to hear that your table is working fine now.

avichaisomper
Starting Member

1 Post

Posted - 2014-12-03 : 06:51:38

Try to find something here unspammed maybe u ll solve yoor problem)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources