STATMAN error 208 
Author Message
 STATMAN error 208

Hi all,

really wierd error.   I have a job one on the intermediate
steps fails.   It called a stored proc which basically
performs some tree walking and some agregations.

if i run the sp manually it works, if i invoke the
individual step it works.  if the step is invoked
automatically it doesnt.

I have traced the execution and regardless of which method
of execution i use I always get this:


        FROM (SELECT TOP 100 PERCENT [BranchID],[LeafID]
FROM [dbo].[Leaf] WITH(READUNCOMMITTED,SAMPLE
1.000000e+002 PERCENT) ORDER BY [BranchID],[LeafID]) AS
_MS_UPDSTATS_TBL OPTION (BYPASS OPTIMIZER_QUEUE, MAXDOP 1)

Error: 208, Severity: 16, State: 0

this statement is not in my code.  I assume that it is
statistics related.  The strange ting is that this msg is
never echoed back when the sp is run.  it is only visible
in profiler.  any ideas ?

Mike



Mon, 15 Aug 2005 22:44:11 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. dbexport error 208 (mem. alloc error)

2. Error 208 when updating stored procedure

3. error 208: invalid object name 'syssubscriptions'

4. Error 208: Invalid object name 'syssubscriptions'

5. Error 208: Invalid object name 'MSrepl_identity_range'

6. Error 208: Invalid Object name....

7. ODBC error 208 (42S02) Invalid object name ....

8. Replication Distribution Agent: Error 208

9. ERROR 208: #TempTable in Stored Proc Creation

10. error 208 on STORED PROC CALL

11. Error 208: Invalid object name 'MSrepl_identity_range'

12. Error 208 Invalid object name '...'


 
Powered by phpBB® Forum Software