Why does the server return Error 9104 "auto statistics internal" I can't find an error description in BOL, MSDN or through a groups/forum search either.
We running Sql Server 2005 (no sp yet) on Windows 2003 server.
Thanks
Error 9104
Hot Topic
- DTC problem with Linked servers between SQL2k and MSDE
- Error in SQL Server Management Studio Express when Attach DB
- Time Intelligence gives this failure if X64bit installed on a different drive
- Combine Data and Split into separate txt files for each header/detail row groupings
- Howto: Save prediction query results to relational table
- "Attempted to read or write protected memory error" in SSIS
- Privileges for Deploying Reports
- is there any way to get isqlw running under sql 2005 install
- How to browse a cube using a web browser
- Row id in sql server....
SQL Server
- Database for workload analysis
- Flat File Source Column Parsing Error
- lookup and commit; How it works
- Getting field value in Select Statement
- SQL Server Express License question
- distributing subscriber database on multiple machine - install
- Dimensions with complex hierarchies ????
- Optimize for CPU load
- display time for tooltips on reports built in Reportserver
- ReportViewer with Authentication
Error 9104
JWTK
Hi Mark,
I only have the severity level, 16. I don't capture the state in my error trace.
We migrated to 2005 in mid-March and this error has been returned twice.
sajid mayo
Error 9104 is used internally for control flow. It is never surfaced through T-SQL. I assume you ran a trace to capture errors.
9104 essentially means that auto statistics failed for some reason (deadlock, resource crunch, ...). Since the engine can go on without auto-created or auto-refreshed statistics, the engine doesn't surface this error.
Peter Zabback
SQL Server Optimizer Development
Jessica Alba