SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Table has corruption.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Vinnie881
Flowing Fount of Yak Knowledge

USA
1222 Posts

Posted - 05/10/2014 :  12:06:31  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
1222 Posts

Posted - 05/10/2014 :  18:36:47  Show Profile  Reply with Quote
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
Go to Top of Page

prett
Posting Yak Master

USA
204 Posts

Posted - 05/14/2014 :  01:27:44  Show Profile  Visit prett's Homepage  Reply with Quote
Nice to hear that your table is working fine now.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000