Re: specific users on the tempbDB

From: Rich (Rich_at_discussions.microsoft.com)
Date: 04/19/05

  • Next message: John Grandy: "DOMAIN\REMOTE_MACHINE_NAME$ account" 
    Date: Tue, 19 Apr 2005 13:25:04 -0700

    Hey Jens,
    perfect, thanks, you are helping me win a big battle I got going on!

    "Jens Süßmeyer" wrote:

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

  • Next message: John Grandy: "DOMAIN\REMOTE_MACHINE_NAME$ account"

    Relevant Pages