only problem is that I have set of 40 tables on which I want to setup the trace.

Interesting. I wonder if everyone else is also experiencing the same thing. I also have a test cluster in which I see Analysis Services but dont see integration services or...

behaviour is same whether I am on the clustered instance or on the active node. Still dont see those missing items.

Well I found out that is the normal behaviour.

http://support.microsoft.com/default.aspx?scid=kb;en-us;195565

The basic algorithm for auto update statistics is:

I was using a maintenance plan to accomplish those tasks. DBCC CHECKDB doesnot release any free space. or does it?

well lets say I want to find out distribution per spid of 300,000 locks. i guess this will have to be real time.

I am not sure if English Query would let you do that. But you might want to look at it.

Well you might want to think about scheduling a job to shrink transaction logs.

interesting.. did you install sp1?

unable to delete the table. any other ideas?

i had a similar post a few months ago.

are you sure you have the latest service pack installed? i remember I had update sql server upto build 8.0.2187. previous...

I would either go with MCITP of MCTS.

once I delete these tables do I need to restart the job or does subscription knows what needs to be done?

I am seeing this in the job history as well as under the last action column of subscription window.

do you mean i should delete all the records from MSdistribution_access table...

yes. it is related to replication. I am getting this error after creating a pull subscription. my source db is on a different server. does the user caci\stellar needs access...