December 20, 2009 at 6:43 pm
There is a login which needs acccess to tempdb. The access is gone after the sql server is recycled. So i set a job which kicks off every min to grant access but i am looking a way in which this job doesnt write to msdb because i do not want to fill up the logs in msdb. I know i can increase the logs in msdb but is there a way where i can schedule this job without updating msdb or if anyone has a better idea to grant permissions after each recycle that will be appreciated. Thanks
December 21, 2009 at 6:39 am
You can write script to grant permission to tempdb and set this script to run as startup script when sql server starts
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 21, 2009 at 9:39 am
Another option is just to apply the required permissions to the model database !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
December 21, 2009 at 9:45 am
Why? What are you doing that requires explicit permission in TempDB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2009 at 2:45 am
Yes, tempdb is taking the templet from model database hence second option will also work nicely 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply