How can you mark a stored proc as a startup procedure and have it run automatically in your DB. not the master DB?

Increased the temp DB size to 70M and tried; the sp ran 3 sec less than before in the first run.

Thank you all for your feedback,

I was able to pin point the bottelneck in the stroed proc when it is first run after a SQL server start or when a...

I've been working on the tuning of the SP for more than a week, and was able to get it down to 5 sec, but this 5 sec can't be...

The stored proc is a bit large (has over 1300 line) it generates a report (No updates or inserts to actual tables) but it has many variable tables and functions...

Understood, but is there a way to control the existance of the execution plan in memory? or have SQL server create it automatically when it starts, provided that the SP...