SQL Server Performance Forum – Threads Archive
Users in tempdb
HiI use the tempdb in a stored procedure but i am having some problems with it because every so often (every 8 weeks or so) it seems to reset the user list and so some of the users are unable to run the stored procedure. Does the tempdb reset itself then? Is there a way to add users to the user list after the database has ‘reset’ itself? Thanks
CE
How often you restart SQL server services?
If so prepare set of SQL statements to add these users and whenever SQL services restarted run this script to add those users. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
alternatively you should be able to add the users to the model database, which is what gets copied over top of tempdb everytime the SQLServer service is started Cheers
Twan
I’m confused. WHY would you give users access to tempdb like this? Doesn’t this bother anyone????? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
]]>