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.
| Author |
Topic |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-07-16 : 13:18:55
|
| When i run TKizers sp to check database integrity. I'm getting this error.Executed as user: IAPE\SQLAdmin. ...536) DBCC results for 'sysobjects'. [SQLSTATE 01000] (Message 2536) There are 1364 rows in 23 pages for object 'sysobjects'. [SQLSTATE 01000] (Message 2593) DBCC results for 'sysindexes'. [SQLSTATE 01000] (Message 2536) There are 138 rows in 5 pages for object 'sysindexes'. [SQLSTATE 01000] (Message 2593) DBCC results for 'syscolumns'. [SQLSTATE 01000] (Message 2536) There are 5251 rows in 104 pages for object 'syscolumns'. [SQLSTATE 01000] (Message 2593) DBCC results for 'systypes'. [SQLSTATE 01000] (Message 2536) There are 26 rows in 1 pages for object 'systypes'. [SQLSTATE 01000] (Message 2593) DBCC results for 'syscomments'. [SQLSTATE 01000] (Message 2536) There are 2115 rows in 1112 pages for object 'syscomments'. [SQLSTATE 01000] (Message 2593) DBCC results for 'sysfiles1'. [SQLSTATE 01000] (Message 2536) There are 2 rows in 1 pages for object 'sysfiles1'. [SQLSTATE 01000] (Message 2593) DBCC results for 'syspermissions'. [SQLSTATE... The step failed.=============================http://www.sqlserverstudy.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-16 : 13:53:46
|
| Moving this to the data corruption forum.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-17 : 15:35:22
|
| You need to run DBCC CHECKDB on the problematic database, then post the entire result set in this forum. They can't help without this information.To see which database is having the issue, run isp_DBCC_CHECK in Query Analyzer/SSMS and then check where the error is coming from. Alternatively, you could run DBCC CHECKDB one each of your databases until you find the one that has errors.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-07-17 : 17:52:15
|
| i ran it on QA. No errors. But the sql job is still failing. I have the sql job enable and uses the SA user.=============================http://www.sqlserverstudy.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-17 : 17:59:13
|
| It works fine for me.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
dbcc checkdb