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

so much for outsourcing development. my production dbas in india are top notch though.

first, the server should be rarely rebooted. if it is being rebooted regularly, you may have other issues. second the tempDB is recreated from a copy of the model db everytime you reboot. Hence the name temp.

I'm 99% sure it was sig-spam, I don't think there is any real question. I neutered the URLs just in case.

-PatP

Third, you shouldn't need dbo on tempdb. It sounds like your application is misusing that database.

pootle flump ur codings are working excelent.

I was going to do similar however at first glance that question has been asked only a couple of times elsewhere this week.

Anyway, if this is indicative of their development expertise then the quality of their applications is certainly open to question.

pootle flump ur codings are working excelent.

nobody comes here for help anymore. have i trolled this board to death finally?