Re: specific users on the tempbDB

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 04/19/05 

Date: Tue, 19 Apr 2005 22:07:45 +0200

Just have a look in your BOL uner System Architecture -->
Systemdatabases --> TEMPDB

HTH, Jens Suessmeyer. 

---
http://www.sqlserver2005.de
---
"Rich" <Rich@discussions.microsoft.com> schrieb im Newsbeitrag 
news:11E27612-2CE7-4F39-9B2A-55A60B81DD8F@microsoft.com...
> Hello Jens:
> That would seem to explain why the users they accumilate along the way 
> flush
> out everytime the server is restarted.  Do you have a link on Microsoft 
> site
> that has that in print?
>
> "Jens Süßmeyer" wrote:
>
>> TempDB is recreated every restart of SQLServer.
>>
>>
>> HTH, Jens Suessmeyer.
>>
>> ---
>> http://www.sqlserver2005.de
>> ---
>>
>>
>>
>> "Rich" <Rich@discussions.microsoft.com> schrieb im Newsbeitrag
>> news:683F0E68-88ED-4B8C-A85E-F795DCC586CE@microsoft.com...
>> > Here is a strange one.  My developers have on the development server 
>> > have
>> > several users placed on the TemDB table.  When you restart the SQL 
>> > Server,
>> > the users that they placed there are now gone, why?  TempDB is a system
>> > table
>> > but I did not know if you restart the service, it would clear users 
>> > that
>> > have
>> > permissions set to it special.  Does anyone have a link to this 
>> > problem?
>>
>>
>>

Relevant Pages