role permission of tempdb due to server restart

[ctatvasoft]

in our application that need to create some tables in tempdb. The user
(call it APP) is not sa. Everytime that the server need to be rebooted, the
db_owner role on tempdb for user APP disappear. So...


1. Is there any setting to ensure that the the db_owner role on tempdb for
user APP will remain after server reboot?


2. If not,
Is there any solustion to run a script at server startup?
And does anybody have a script that will create the db_owner role on tempdb
for user APP(or some pointer on how)?

Chirag Vyas
Project Manager
Software Outsourcing India
Web Development Company India