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
205 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

avichaisomper
Starting Member

1 Posts

Posted - 12/03/2014 :  06:51:38  Show Profile  Reply with Quote
Try to find something here unspammed maybe u ll solve yoor problem)
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