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 |
|
Squiffy
Starting Member
8 Posts |
 Posted - 2010-12-03 : 01:45:42
|
| SQL Server 2008 SP1VS VB 2008This has got me.I have a table with records in it. I can see all the records using the management studio.When I use the query 'select * from staffdiary' some of the records are not returned in VS. Always the same records no matter what you do.Even the absoluteposition shows records being skipedThe same query in SSMS returns all the records no problem.Is this a corruption issue. I tried to repair the DB by EXEC sp_resetstatus teamtrack; ALTER DATABASE teamtrack SET EMERGENCY DBCC checkdb(teamtrack) ALTER DATABASE teamtrack SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (teamtrack, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE teamtrack SET MULTI_USERand no problems were reported.Any ideas?Thanks in advance.The suspect flag on the database "teamtrack" is already reset.DBCC results for 'TEAMTRACK'.Service Broker Msg 9675, State 1: Message Types analyzed: 14.Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.Service Broker Msg 9667, State 1: Services analyzed: 3.Service Broker Msg 9668, State 1: Service Queues analyzed: 3.Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.DBCC results for 'sys.sysrscols'.There are 1552 rows in 38 pages for object "sys.sysrscols".DBCC results for 'sys.sysrowsets'.There are 164 rows in 2 pages for object "sys.sysrowsets".DBCC results for 'sys.sysallocunits'.There are 193 rows in 3 pages for object "sys.sysallocunits".DBCC results for 'sys.sysfiles1'.There are 2 rows in 1 pages for object "sys.sysfiles1".DBCC results for 'sys.syspriorities'.There are 0 rows in 0 pages for object "sys.syspriorities".DBCC results for 'sys.sysfgfrag'.There are 2 rows in 1 pages for object "sys.sysfgfrag".DBCC results for 'sys.sysphfg'.There are 1 rows in 1 pages for object "sys.sysphfg".DBCC results for 'sys.sysprufiles'.There are 2 rows in 1 pages for object "sys.sysprufiles".DBCC results for 'sys.sysftinds'.There are 0 rows in 0 pages for object "sys.sysftinds".DBCC results for 'sys.sysowners'.There are 17 rows in 1 pages for object "sys.sysowners".DBCC results for 'sys.sysprivs'.There are 152 rows in 1 pages for object "sys.sysprivs".DBCC results for 'sys.sysschobjs'.There are 648 rows in 14 pages for object "sys.sysschobjs".DBCC results for 'sys.syscolpars'.There are 1312 rows in 40 pages for object "sys.syscolpars".DBCC results for 'sys.sysnsobjs'.There are 1 rows in 1 pages for object "sys.sysnsobjs".DBCC results for 'sys.syscerts'.There are 0 rows in 0 pages for object "sys.syscerts".DBCC results for 'sys.sysxprops'.There are 9 rows in 1 pages for object "sys.sysxprops".DBCC results for 'sys.sysscalartypes'.There are 34 rows in 1 pages for object "sys.sysscalartypes".DBCC results for 'sys.systypedsubobjs'.There are 0 rows in 0 pages for object "sys.systypedsubobjs".DBCC results for 'sys.sysidxstats'.There are 806 rows in 29 pages for object "sys.sysidxstats".DBCC results for 'sys.sysiscols'.There are 955 rows in 9 pages for object "sys.sysiscols".DBCC results for 'sys.sysbinobjs'.There are 23 rows in 1 pages for object "sys.sysbinobjs".DBCC results for 'sys.sysaudacts'.There are 0 rows in 0 pages for object "sys.sysaudacts".DBCC results for 'sys.sysobjvalues'.There are 1321 rows in 269 pages for object "sys.sysobjvalues".DBCC results for 'sys.sysclsobjs'.There are 16 rows in 1 pages for object "sys.sysclsobjs".DBCC results for 'sys.sysrowsetrefs'.There are 0 rows in 0 pages for object "sys.sysrowsetrefs".DBCC results for 'sys.sysremsvcbinds'.There are 0 rows in 0 pages for object "sys.sysremsvcbinds".DBCC results for 'sys.sysxmitqueue'.There are 0 rows in 0 pages for object "sys.sysxmitqueue".DBCC results for 'sys.sysrts'.There are 1 rows in 1 pages for object "sys.sysrts".DBCC results for 'sys.sysconvgroup'.There are 0 rows in 0 pages for object "sys.sysconvgroup".DBCC results for 'sys.sysdesend'.There are 0 rows in 0 pages for object "sys.sysdesend".DBCC results for 'sys.sysdercv'.There are 0 rows in 0 pages for object "sys.sysdercv".DBCC results for 'sys.syssingleobjrefs'.There are 161 rows in 1 pages for object "sys.syssingleobjrefs".DBCC results for 'sys.sysmultiobjrefs'.There are 145 rows in 1 pages for object "sys.sysmultiobjrefs".DBCC results for 'sys.sysguidrefs'.There are 0 rows in 0 pages for object "sys.sysguidrefs".DBCC results for 'sys.syscompfragments'.There are 0 rows in 0 pages for object "sys.syscompfragments".DBCC results for 'sys.sysftstops'.There are 0 rows in 0 pages for object "sys.sysftstops".DBCC results for 'sys.sysqnames'.There are 97 rows in 1 pages for object "sys.sysqnames".DBCC results for 'sys.sysxmlcomponent'.There are 99 rows in 1 pages for object "sys.sysxmlcomponent".DBCC results for 'sys.sysxmlfacet'.There are 112 rows in 1 pages for object "sys.sysxmlfacet".DBCC results for 'sys.sysxmlplacement'.There are 18 rows in 1 pages for object "sys.sysxmlplacement".DBCC results for 'sys.sysobjkeycrypts'.There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".DBCC results for 'sys.sysasymkeys'.There are 0 rows in 0 pages for object "sys.sysasymkeys".DBCC results for 'sys.syssqlguides'.There are 0 rows in 0 pages for object "sys.syssqlguides".DBCC results for 'sys.sysbinsubobjs'.There are 3 rows in 1 pages for object "sys.sysbinsubobjs".DBCC results for 'sys.syssoftobjrefs'.There are 8 rows in 1 pages for object "sys.syssoftobjrefs".DBCC results for 'DEPTDIARY_CACHE'.There are 6 rows in 2 pages for object "DEPTDIARY_CACHE".DBCC results for 'INCIDENT_CACHE'.There are 0 rows in 0 pages for object "INCIDENT_CACHE".DBCC results for 'MERIT'.There are 5590 rows in 32 pages for object "MERIT".DBCC results for 'INTERFACE_LOG'.There are 31 rows in 9 pages for object "INTERFACE_LOG".DBCC results for 'SUB_CATEGORIES'.There are 9610 rows in 154 pages for object "SUB_CATEGORIES".DBCC results for 'LOG'.There are 96145 rows in 842 pages for object "LOG".DBCC results for 'STAFFDIARY'.There are 5651 rows in 197 pages for object "STAFFDIARY".DBCC results for 'POSITIONS'.There are 252 rows in 17 pages for object "POSITIONS".DBCC results for 'IMPORT_STAFF'.There are 0 rows in 149 pages for object "IMPORT_STAFF".DBCC results for 'NETWORK'.There are 91 rows in 2 pages for object "NETWORK".DBCC results for 'INCIDENT'.There are 5 rows in 2 pages for object "INCIDENT".DBCC results for 'OLD_PASSWORDS'.There are 132 rows in 1 pages for object "OLD_PASSWORDS".DBCC results for 'PROPERTY'.There are 2 rows in 1 pages for object "PROPERTY".DBCC results for 'CATEGORIES'.There are 177 rows in 10 pages for object "CATEGORIES".DBCC results for 'IMPORT_SKILL'.There are 0 rows in 99 pages for object "IMPORT_SKILL".DBCC results for 'SICK_DAYS'.There are 25742 rows in 147 pages for object "SICK_DAYS".DBCC results for 'HELD_ASSESSMENTS'.There are 0 rows in 13 pages for object "HELD_ASSESSMENTS".DBCC results for 'SKILLS'.There are 33613 rows in 224 pages for object "SKILLS".DBCC results for 'sys.filestream_tombstone_777769828'.There are 0 rows in 0 pages for object "sys.filestream_tombstone_777769828".DBCC results for 'IMPORT_SICK'.There are 0 rows in 63 pages for object "IMPORT_SICK".DBCC results for 'sys.syscommittab'.There are 4106 rows in 42 pages for object "sys.syscommittab".DBCC results for 'SKILL_CODES'.There are 264 rows in 3 pages for object "SKILL_CODES".DBCC results for 'SORTS'.There are 17 rows in 4 pages for object "SORTS".DBCC results for 'EMPLOYEES'.There are 4999 rows in 756 pages for object "EMPLOYEES".DBCC results for 'sysdiagrams'.There are 0 rows in 1 pages for object "sysdiagrams".DBCC results for 'INTERFACE'.There are 220 rows in 3 pages for object "INTERFACE".DBCC results for 'sys.change_tracking_308912172'.There are 380 rows in 3 pages for object "sys.change_tracking_308912172".DBCC results for 'sys.change_tracking_1400392058'.There are 0 rows in 1 pages for object "sys.change_tracking_1400392058".DBCC results for 'sys.change_tracking_1876917758'.There are 9 rows in 1 pages for object "sys.change_tracking_1876917758".DBCC results for 'sys.change_tracking_366012435'.There are 2 rows in 1 pages for object "sys.change_tracking_366012435".DBCC results for 'sys.change_tracking_1796917473'.There are 2 rows in 1 pages for object "sys.change_tracking_1796917473".DBCC results for 'sys.change_tracking_1508916447'.There are 1 rows in 1 pages for object "sys.change_tracking_1508916447".DBCC results for 'MAPPING'.There are 2 rows in 1 pages for object "MAPPING".DBCC results for 'SHIFT_REPORT'.There are 67 rows in 43 pages for object "SHIFT_REPORT".DBCC results for 'sys.change_tracking_1883153754'.There are 0 rows in 1 pages for object "sys.change_tracking_1883153754".DBCC results for 'sys.change_tracking_316632271'.There are 15 rows in 1 pages for object "sys.change_tracking_316632271".DBCC results for 'DEPARTMENTS'.There are 15 rows in 1 pages for object "DEPARTMENTS".DBCC results for 'DEPTDIARYCATS'.There are 26 rows in 4 pages for object "DEPTDIARYCATS".DBCC results for 'DIARYCATS'.There are 44 rows in 5 pages for object "DIARYCATS".DBCC results for 'PIT_REPORT'.There are 280 rows in 18 pages for object "PIT_REPORT".DBCC results for 'PRINTJOB'.There are 1 rows in 2 pages for object "PRINTJOB".DBCC results for 'ASSESSMENT_CACHE'.There are 7 rows in 2 pages for object "ASSESSMENT_CACHE".DBCC results for 'MERIT_CATS'.There are 8 rows in 3 pages for object "MERIT_CATS".DBCC results for 'MAINTENANCE'.There are 1 rows in 1 pages for object "MAINTENANCE".DBCC results for 'SUB_CATEGORIES_DATA'.There are 33565 rows in 238 pages for object "SUB_CATEGORIES_DATA".DBCC results for 'POSAVG'.There are 498 rows in 14 pages for object "POSAVG".DBCC results for 'DEPTDIARY'.There are 7 rows in 1 pages for object "DEPTDIARY".DBCC results for 'STAFF_IMAGES'.There are 2 rows in 1 pages for object "STAFF_IMAGES".DBCC results for 'STAFFDIARY_CACHE'.There are 7 rows in 1 pages for object "STAFFDIARY_CACHE".DBCC results for 'sys.queue_messages_1977058079'.There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".DBCC results for 'SETTINGS'.There are 1 rows in 1 pages for object "SETTINGS".DBCC results for 'sys.queue_messages_2009058193'.There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".DBCC results for 'TEMPLATES'.There are 0 rows in 1 pages for object "TEMPLATES".DBCC results for 'sys.queue_messages_2041058307'.There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".DBCC results for 'ASSESSMENTS'.There are 1294 rows in 261 pages for object "ASSESSMENTS".CHECKDB found 0 allocation errors and 0 consistency errors in database 'TEAMTRACK'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.DBCC results for 'TEAMTRACK'.Service Broker Msg 9675, State 1: Message Types analyzed: 14.Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.Service Broker Msg 9667, State 1: Services analyzed: 3.Service Broker Msg 9668, State 1: Service Queues analyzed: 3.Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.DBCC results for 'sys.sysrscols'.There are 1552 rows in 38 pages for object "sys.sysrscols".DBCC results for 'sys.sysrowsets'.There are 164 rows in 2 pages for object "sys.sysrowsets".DBCC results for 'sys.sysallocunits'.There are 193 rows in 3 pages for object "sys.sysallocunits".DBCC results for 'sys.sysfiles1'.There are 2 rows in 1 pages for object "sys.sysfiles1".DBCC results for 'sys.syspriorities'.There are 0 rows in 0 pages for object "sys.syspriorities".DBCC results for 'sys.sysfgfrag'.There are 2 rows in 1 pages for object "sys.sysfgfrag".DBCC results for 'sys.sysphfg'.There are 1 rows in 1 pages for object "sys.sysphfg".DBCC results for 'sys.sysprufiles'.There are 2 rows in 1 pages for object "sys.sysprufiles".DBCC results for 'sys.sysftinds'.There are 0 rows in 0 pages for object "sys.sysftinds".DBCC results for 'sys.sysowners'.There are 17 rows in 1 pages for object "sys.sysowners".DBCC results for 'sys.sysprivs'.There are 152 rows in 1 pages for object "sys.sysprivs".DBCC results for 'sys.sysschobjs'.There are 648 rows in 14 pages for object "sys.sysschobjs".DBCC results for 'sys.syscolpars'.There are 1312 rows in 40 pages for object "sys.syscolpars".DBCC results for 'sys.sysnsobjs'.There are 1 rows in 1 pages for object "sys.sysnsobjs".DBCC results for 'sys.syscerts'.There are 0 rows in 0 pages for object "sys.syscerts".DBCC results for 'sys.sysxprops'.There are 9 rows in 1 pages for object "sys.sysxprops".DBCC results for 'sys.sysscalartypes'.There are 34 rows in 1 pages for object "sys.sysscalartypes".DBCC results for 'sys.systypedsubobjs'.There are 0 rows in 0 pages for object "sys.systypedsubobjs".DBCC results for 'sys.sysidxstats'.There are 806 rows in 29 pages for object "sys.sysidxstats".DBCC results for 'sys.sysiscols'.There are 955 rows in 9 pages for object "sys.sysiscols".DBCC results for 'sys.sysbinobjs'.There are 23 rows in 1 pages for object "sys.sysbinobjs".DBCC results for 'sys.sysaudacts'.There are 0 rows in 0 pages for object "sys.sysaudacts".DBCC results for 'sys.sysobjvalues'.There are 1321 rows in 269 pages for object "sys.sysobjvalues".DBCC results for 'sys.sysclsobjs'.There are 16 rows in 1 pages for object "sys.sysclsobjs".DBCC results for 'sys.sysrowsetrefs'.There are 0 rows in 0 pages for object "sys.sysrowsetrefs".DBCC results for 'sys.sysremsvcbinds'.There are 0 rows in 0 pages for object "sys.sysremsvcbinds".DBCC results for 'sys.sysxmitqueue'.There are 0 rows in 0 pages for object "sys.sysxmitqueue".DBCC results for 'sys.sysrts'.There are 1 rows in 1 pages for object "sys.sysrts".DBCC results for 'sys.sysconvgroup'.There are 0 rows in 0 pages for object "sys.sysconvgroup".DBCC results for 'sys.sysdesend'.There are 0 rows in 0 pages for object "sys.sysdesend".DBCC results for 'sys.sysdercv'.There are 0 rows in 0 pages for object "sys.sysdercv".DBCC results for 'sys.syssingleobjrefs'.There are 161 rows in 1 pages for object "sys.syssingleobjrefs".DBCC results for 'sys.sysmultiobjrefs'.There are 145 rows in 1 pages for object "sys.sysmultiobjrefs".DBCC results for 'sys.sysguidrefs'.There are 0 rows in 0 pages for object "sys.sysguidrefs".DBCC results for 'sys.syscompfragments'.There are 0 rows in 0 pages for object "sys.syscompfragments".DBCC results for 'sys.sysftstops'.There are 0 rows in 0 pages for object "sys.sysftstops".DBCC results for 'sys.sysqnames'.There are 97 rows in 1 pages for object "sys.sysqnames".DBCC results for 'sys.sysxmlcomponent'.There are 99 rows in 1 pages for object "sys.sysxmlcomponent".DBCC results for 'sys.sysxmlfacet'.There are 112 rows in 1 pages for object "sys.sysxmlfacet".DBCC results for 'sys.sysxmlplacement'.There are 18 rows in 1 pages for object "sys.sysxmlplacement".DBCC results for 'sys.sysobjkeycrypts'.There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".DBCC results for 'sys.sysasymkeys'.There are 0 rows in 0 pages for object "sys.sysasymkeys".DBCC results for 'sys.syssqlguides'.There are 0 rows in 0 pages for object "sys.syssqlguides".DBCC results for 'sys.sysbinsubobjs'.There are 3 rows in 1 pages for object "sys.sysbinsubobjs".DBCC results for 'sys.syssoftobjrefs'.There are 8 rows in 1 pages for object "sys.syssoftobjrefs".DBCC results for 'DEPTDIARY_CACHE'.There are 6 rows in 2 pages for object "DEPTDIARY_CACHE".DBCC results for 'INCIDENT_CACHE'.There are 0 rows in 0 pages for object "INCIDENT_CACHE".DBCC results for 'MERIT'.There are 5590 rows in 32 pages for object "MERIT".DBCC results for 'INTERFACE_LOG'.There are 31 rows in 9 pages for object "INTERFACE_LOG".DBCC results for 'SUB_CATEGORIES'.There are 9610 rows in 154 pages for object "SUB_CATEGORIES".DBCC results for 'LOG'.There are 96145 rows in 842 pages for object "LOG".DBCC results for 'STAFFDIARY'.There are 5651 rows in 197 pages for object "STAFFDIARY".DBCC results for 'POSITIONS'.There are 252 rows in 17 pages for object "POSITIONS".DBCC results for 'IMPORT_STAFF'.There are 0 rows in 149 pages for object "IMPORT_STAFF".DBCC results for 'NETWORK'.There are 91 rows in 2 pages for object "NETWORK".DBCC results for 'INCIDENT'.There are 5 rows in 2 pages for object "INCIDENT".DBCC results for 'OLD_PASSWORDS'.There are 132 rows in 1 pages for object "OLD_PASSWORDS".DBCC results for 'PROPERTY'.There are 2 rows in 1 pages for object "PROPERTY".DBCC results for 'CATEGORIES'.There are 177 rows in 10 pages for object "CATEGORIES".DBCC results for 'IMPORT_SKILL'.There are 0 rows in 99 pages for object "IMPORT_SKILL".DBCC results for 'SICK_DAYS'.There are 25742 rows in 147 pages for object "SICK_DAYS".DBCC results for 'HELD_ASSESSMENTS'.There are 0 rows in 13 pages for object "HELD_ASSESSMENTS".DBCC results for 'SKILLS'.There are 33613 rows in 224 pages for object "SKILLS".DBCC results for 'sys.filestream_tombstone_777769828'.There are 0 rows in 0 pages for object "sys.filestream_tombstone_777769828".DBCC results for 'IMPORT_SICK'.There are 0 rows in 63 pages for object "IMPORT_SICK".DBCC results for 'sys.syscommittab'.There are 3106 rows in 42 pages for object "sys.syscommittab".DBCC results for 'SKILL_CODES'.There are 264 rows in 3 pages for object "SKILL_CODES".DBCC results for 'SORTS'.There are 17 rows in 4 pages for object "SORTS".DBCC results for 'EMPLOYEES'.There are 4999 rows in 756 pages for object "EMPLOYEES".DBCC results for 'sysdiagrams'.There are 0 rows in 1 pages for object "sysdiagrams".DBCC results for 'INTERFACE'.There are 220 rows in 3 pages for object "INTERFACE".DBCC results for 'sys.change_tracking_308912172'.There are 380 rows in 3 pages for object "sys.change_tracking_308912172".DBCC results for 'sys.change_tracking_1400392058'.There are 0 rows in 1 pages for object "sys.change_tracking_1400392058".DBCC results for 'sys.change_tracking_1876917758'.There are 9 rows in 1 pages for object "sys.change_tracking_1876917758".DBCC results for 'sys.change_tracking_366012435'.There are 2 rows in 1 pages for object "sys.change_tracking_366012435".DBCC results for 'sys.change_tracking_1796917473'.There are 2 rows in 1 pages for object "sys.change_tracking_1796917473".DBCC results for 'sys.change_tracking_1508916447'.There are 1 rows in 1 pages for object "sys.change_tracking_1508916447".DBCC results for 'MAPPING'.There are 2 rows in 1 pages for object "MAPPING".DBCC results for 'SHIFT_REPORT'.There are 67 rows in 43 pages for object "SHIFT_REPORT".DBCC results for 'sys.change_tracking_1883153754'.There are 0 rows in 1 pages for object "sys.change_tracking_1883153754".DBCC results for 'sys.change_tracking_316632271'.There are 15 rows in 1 pages for object "sys.change_tracking_316632271".DBCC results for 'DEPARTMENTS'.There are 15 rows in 1 pages for object "DEPARTMENTS".DBCC results for 'DEPTDIARYCATS'.There are 26 rows in 4 pages for object "DEPTDIARYCATS".DBCC results for 'DIARYCATS'.There are 44 rows in 5 pages for object "DIARYCATS".DBCC results for 'PIT_REPORT'.There are 280 rows in 18 pages for object "PIT_REPORT".DBCC results for 'PRINTJOB'.There are 1 rows in 2 pages for object "PRINTJOB".DBCC results for 'ASSESSMENT_CACHE'.There are 7 rows in 2 pages for object "ASSESSMENT_CACHE".DBCC results for 'MERIT_CATS'.There are 8 rows in 3 pages for object "MERIT_CATS".DBCC results for 'MAINTENANCE'.There are 1 rows in 1 pages for object "MAINTENANCE".DBCC results for 'SUB_CATEGORIES_DATA'.There are 33565 rows in 238 pages for object "SUB_CATEGORIES_DATA".DBCC results for 'POSAVG'.There are 498 rows in 14 pages for object "POSAVG".DBCC results for 'DEPTDIARY'.There are 7 rows in 1 pages for object "DEPTDIARY".DBCC results for 'STAFF_IMAGES'.There are 2 rows in 1 pages for object "STAFF_IMAGES".DBCC results for 'STAFFDIARY_CACHE'.There are 7 rows in 1 pages for object "STAFFDIARY_CACHE".DBCC results for 'sys.queue_messages_1977058079'.There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".DBCC results for 'SETTINGS'.There are 1 rows in 1 pages for object "SETTINGS".DBCC results for 'sys.queue_messages_2009058193'.There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".DBCC results for 'TEMPLATES'.There are 0 rows in 1 pages for object "TEMPLATES".DBCC results for 'sys.queue_messages_2041058307'.There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".DBCC results for 'ASSESSMENTS'.There are 1294 rows in 261 pages for object "ASSESSMENTS".CHECKDB found 0 allocation errors and 0 consistency errors in database 'TEAMTRACK'.DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-03 : 04:37:19
|
| why did you try to repair the database?The reows are all returned via a query so it's obviously an application issue.Either it can't handle the data in the table or there's a coding error.Try selecting just one column - try with a varchar column and an int column.If that doesn't help then copy the column data into another table and try that.If that doesn't help try selecting a subset of rows (top 10 for instance).If that doesn't help then have you ever coded this sort of thing successfuly.If you have then try changing the code to something that has been successful and see if that works.If it does then it's probably a data issueIf it doesn't then it's nothing to do with the database.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Squiffy
Starting Member
8 Posts |
Posted - 2010-12-03 : 05:30:26
|
| Thanks nigelrivettYou were right. It was the code.I couldn't see the trees for the forrest. |
|
|
|
|
|
|
|
|
Records not returning