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
- accessing report server programmatically
- Configuration of SQL Server 2000 Instance
- ORDER BY error
- Help with IIf statement in expression
- Flags on a table
- It doesnt execute my assemblies.
- Trying to install SQL Server 2005 Express Edition
- Calculated Measure will not deploy
- To find all pairs in table that fits to given criteria.
- spid3 SQL Server is terminating due to 'stop' request from Service Control Manager
SQL Server
- 2005 April CTP Install Failure
- Returning results to MSMQ from SSIS Package
- Passing DataTable to Reporting Services 2000
- Can't put an array into an object variable
- Placing Database under Visual Source Safe Source Control
- SSIS Versioning Control
- Unable to uninstall SQL Server Express 2005 Tools
- Cannot open backup device 'F:\foldername'. Operating system error 5(Access is denied.).
- How do I force new databases to be created on another drive on same server?
- Fuzzy Grouping: Any success with > 3 million records?
Error 9104
herbjorn
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.
R.E
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
gerich