Results 1 to 3 of 3

Thread: About Tempdb

  1. #1
    Join Date
    Feb 2008
    Posts
    27

    Smile Unanswered: About Tempdb

    Hi All,

    i have a doubt about Tempdb, i.e normally we wn't create tempdb, while creating database it automatically allocates some amount space for tempdb,my doubt is that if tempdb is full we will clear that by useing lct_admin or we will create multipule tempdb's. how we will create multipule tempdb's.Can any one help me in detail manar

    Thanks in advance.........

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Syntax
    Code:
    create [temporary] database database_name 
        [on {default | database_device} [= size] 
            [, database_device [= size]]...] 
        [log on database_device [= size] 
            [, database_device [= size]]...]
        [with {override | default_location = "pathname"}]
        [for {load | proxy_update}]
    For more info see Multiple Temporary Databases

  3. #3
    Join Date
    Feb 2008
    Posts
    27
    thanks a lot pdreyer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •