Post reply

VBScript Question

  • June 30, 2005 at 8:38 am

    #87998

    Is there a property of some object in SQL-DMO model that displays the name and path of the log file/files for the SQL 2000 databases?

     

  • June 30, 2005 at 9:46 am

    #569905

    I don't know about SQL-DMO but the query is SELECT * FROM sysfiles from inside the database you want...



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • June 30, 2005 at 9:50 am

    #569907

    Thanks for the reply. In the meantime I found it: Database Object has an object TransactionLog which includes a collection LogFiles. Members of this collection are LogFile objects and one cal list property like name and PhysicalName (= path).  

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

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