I ran the upgrade advisor

I see the red cross mark under the importance for SQL Server. It is showing that Full-Text search has changed in sql server 2008 under the...

Yes. Understood

Thank you.

So triggers are the only option if you don't want have any 3rd party tools!

Thank you.

The stored procedures can't be modify

I am executing a sp in each step. If any step failed either it is executing the sp or just adhoc query I need...

Thank you.

Instead of sending the output through email

If you want to store each run step by step in user database table. How could you do that?

So for each job step I need to include this job right?

How can I display step id where it failed just like @@servername

I attached the screenshot

I started job manually it is showing like running but from job activity monitor not able to see the job and even from sysjobactivity

So I again click on start step...

Thanks for the replies.

What do you mean changes to the cardinality estimator?

Understood.

Thank you

Thank you Jacob

Thank you.

One more question what is the number next to the when you get key resource wait instead of tab.

KEY: 9:72057623741923328(8f6267ec32ff)

What is the no in the parenthesis...

From this below query there are 200 cpu_ids

select scheduler_id, cpu_id, status, is_online

from sys.dm_os_schedulers

where status = 'VISIBLE ONLINE'

Instead of key if the wait resource is tab, how could you find that resource name?

TAB: 5:836198029:106

what is that 106? I can see there are different...