fn_virtualfilestats Sometimes gives no recordset back

• Theo Ekelmans-238002

  Newbie

  Points: 1

  More actions

  October 20, 2005 at 6:36 am

  #90411

  Hi,

   

  I'm creating my own SQL performance management database. For that purpose i use the fn_virtualfilestats function. But sometimes it gives no recordset back.

  It works fine on one SQL server and not on the other. They ALL run SQL2K-SP3a, and all jobs are owned by a sa equivalent user.

  example: SELECT * FROM :: fn_virtualfilestats(1, 1)

  This should give info back for the master.mdf

  Any idea's?

  Theo Ekelmans

  The Vision Web

  The Netherlands

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  October 22, 2005 at 9:54 am

  #599367

  Theo - hoe gaat het ?! Ik woned in Nederlands voor twee jaren..long time back!

  I have never used this function but came across this on the web - sounds like an SP fix!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**