From: hugo@perFact.REMOVETHIS.info.INVALID   
      
   On Sat, 29 Aug 2009 12:34:59 +0000 (UTC), Erland Sommarskog wrote:   
      
   >hayko98 (vardan.hakopian@gmail.com) writes:   
   >> It retuned empty columns.This is the where file located  : Y:\Program   
   >> Files\Microsoft SQL Server\MSSQL\Data.As you notice it is not in   
   >> MSSQL.n folder.I don't know if that would make any difference?   
   >>   
   >> Y:\Program Files\Microsoft SQL Server\MSSQL\Data   
   >   
   >Obviously, you would need to modify Hugo's query to use the actual path.   
      
   And remember to use the drive letter that would be valid on the server   
   that is running the SQL Server instance. If the drive is a network share   
   known as Y: on your workstation but e.g. E: on the server, then you need   
   to use E: as the code is run on the server.   
      
   --   
   Hugo Kornelis, SQL Server MVP   
   My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)