Thank you!!

But after I run the following now I get the results.

UPDATE STATISTICS tbl1 WITH FULLSCAN

This is what happened and very strange to me

select o.name, last_execution_time from sys.dm_exec_procedure_stats ps

inner join sys.objects o

on ps.object_id = o.object_id

where o.type = 'P'

and o.name = 'Proc1'

I was running the...

I renamed the proc to proc2 and it's still showing up as executed few minutes ago though no jobs have failed and still it does not show up in...

Thank you for the reply but still it's not showing up in the trace.

Argggh!! Finally !!! Thanks a bunch.:-)

Good idea. Thanks!

Unfortuantely I have almost 50 databases and it has to be a view since the client is using the view to do a data lookup.

How about using a cursor and a CTE in a view and doing a final select on the CTE in a view? Just thought of it.

I figured out what the issue was. There were two stored procedure calls ( I did not have that code in the post) .

Both calls were using the same...

error:The parameterized query '(@param1 int,@Paramout int OUTPUT)' expects the parameter '@Paramout', which was not supplied.

SQLSteve (8/30/2013)

---

Also, if adding the SPs to all databases on your instance, be sure to add them to the model database so you do not have to go through this...

Thank you and will take a look at it. I do not have multiservers. Just one server but many databases.

Thank yoy for the reply, actually this is what I am trying to do. I have bunch of objects that I need to create on multiple databases. I was...

I forgot to mention that it is just on one server but there are multiple databases