August 11, 2011 at 3:03 pm
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
August 12, 2011 at 5:52 am
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