SQL Server Performance

How to Autoextend for a file.

Discussion in 'General DBA Questions' started by krajdba, May 18, 2006.

  1. krajdba New Member

    Hi Gurus,

    for the databases files I wanted to know files with autoextend on parameter.

    thanks



    raj
  2. Luis Martin Moderator

    Without Entreprise Manager?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



  3. krajdba New Member

    Yes.Without Enterprise Manager

    raj
  4. cmdr_skywalker New Member

    use the query below. change the database name if you have to.

    select name, filename
    from master.dbo.sysfiles
    where growth <> 0

    May the Almighty God bless us all!
    www.empoweredinformation.com
  5. Luis Martin Moderator

    Or sp helpfile


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page