Re: TempDB Configured Minimum Size

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 16:56:39 +0200

master..sysaltfiles 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"jeff" <anonymous@discussions.microsoft.com> wrote in message news:14e601c48c44$067174a0$a601280a@phx.gbl...
> 7.0 server, we restarted the services to reset the tempdb
> to what we beleive is the configured value of 2GB.  Where
> can I check the the value to ensure that the minimum size
> is indeed 2GB and not something else?

Relevant Pages

  • Re: setup a sql login which can only reset password
    ... I couldn't test it right now, because if I login as helpdesk, i reset the ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Log files
    ... Tibor Karaszi, SQL Server MVP ... It is not the transaction log for tempdb, ... Either pre.allocate storage for tempdb, or tweak the query (look at query plan, add ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Calculated field is calculated wrong
    ... USE tempdb ... Tibor Karaszi, SQL Server MVP ... van Laake" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Log files
    ... It is not the transaction log for tempdb, it is the database files. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: setup a sql login which can only reset password
    ... Do you mean that I reset with the old password? ... Tibor Karaszi, SQL Server MVP ... "Cannot alter login ' xxx', because it doesn't exist or you do not ...
    (microsoft.public.sqlserver.server)