• Yes i have benn provided a different physical drive...

    Well i came to know how to move the Datafile & Log files to different location....

    I am just concerned abt TempDB database as there are many stored procedure executing all time..

    WIll moving Tempdb datafile & log file help in improving performance?

    What are the steps for setting the tempdb datafile & log files to other locations???

    Currently the tempdb files are on the same drive, i want to move it to other phyiscal drive....

    ************************************
    Every Dog has a Tail !!!!! :-D