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 21:50:32 +0200

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

  • RE: ASPState Bug/Security issue
    ... what is the proper way to configure SQL ... >!information does not survives a sql restart unless you ... >!tempdb for storage and I'm fine with the downsides. ... >!the stored procs in aspstate and you are good to go. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: tempdb can not delete it
    ... konow it is regenerated normally on restart, but it does not anymore. ... DBCC shrink does not work also.. ... It is recreated every time SQL Server is shutdown and then restarted. ... after a huge ODBC operation to read some data from a DB table, my tempdb is now 2.8 GB and I can not delete tempdb. ...
    (microsoft.public.sqlserver.setup)
  • specific users on the tempbDB
    ... My developers have on the development server have ... several users placed on the TemDB table. ... When you restart the SQL Server, ...
    (microsoft.public.sqlserver.security)
  • gnome-sound-recorder
    ... You can inform the developers of what happened to help them fix it. ... you can restart the application right now. ... To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list ...
    (Fedora)
  • Re: tempDB Concept
    ... Tempdb grows just like any other db that has autogrow set on. ... it was changed using an ALTER DATABASE statement. ... 100MB and grew to 1GB it would go back to 100MB on a restart. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clients)