Better to be safe than sorry...



  • I ran across this beaut on an old server running a 3rd-party reporting tool...

    BACKUP DATABASE [tempdb] TO [System] WITH  INIT ,

    /snip/

    RESTORE VERIFYONLY FROM  [System]  WITH FILE = @i

    Makes reporting on temp tables possible, I guess!


Log in to reply