Permission Denied on DBCC Show_Statistics via linked server foils Optimizer

Question

                                                             

When running a stored procedure on server1 (SQL2000), which includes references to tables on server2 (a linked server -SQL2005), the Optimizer can not obtain a good plan because the account used does not have sufficient permissions to execute DBCC Show_Statistics on server2. This results in excessive run time, rendering the query useless. When run under an account with dbo rights on the database on server2, the query runs fine. This behavior seems like it may be a bug!

 

Has anyone had similar experiences?

 

Terry