Interesting

  • i had added datafiles to tempdb (SQL server 2005).

    How i added the files:

    1)connected to the instance(sql server2005) from sql server 2008 box and there i added .

    2)the thing is when i connected remotely into that server where sql2005 instance resides, i did not find the files in the location.

    3)when i add files from the server where sql 2005 resides, i can find the files.

    My question is why i can not find files added from sql 2008.

    Please help

  • Hi,

    Have you checked (sp_helpdb tempdb) from SSMS 2008 after adding the files? If it shows there it must be seen from SSMS 2005 from the server itself.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply