Post reply

Finding file path

  • May 27, 2008 at 4:55 am

    #95942

    I know the file name with file extension. Need to know complete path of the .exec file located some where in the system.

    Can some one please help me in getting file path using tsql script.

    Thanks a lot!

  • May 27, 2008 at 6:48 am

    #820522

    [font="Verdana"]I doubt, this is possible through TSQL. Better you go and check the File object (I am not sure, under which Namespace it comes) in ASP .Net. You will surely get the file path and a lot more information.

    Mahesh[/font]

    MH-09-AM-8694

  • May 28, 2008 at 12:21 am

    #820992

    use [database]

    select name, physical_name from sys.database_files

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

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