tempdb

• Garutyunyan

  SSCrazy

  Points: 2629

  More actions

  November 30, 2001 at 6:27 pm

  #157948

  Hey guys, anyone know how to change the physical location of the tempdb, from C:(default) to D:\?

  Thanks

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  November 30, 2001 at 11:15 pm

  #420588

  try alter database modify file then restart the server.

  
  Cursors never.
  DTS - only when needed and never to control.