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
(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