Post reply

What drive sql server is installed

  • July 2, 2009 at 10:58 am

    #207855

    I need to know what drive sql server 2005 is installed on? Is there anyway we can find it out using TSQL? I found some info on WMI but I have not used it before and do not know how.

  • July 2, 2009 at 12:26 pm

    #1019389

    John Doe (7/2/2009)

    I need to know what drive sql server 2005 is installed on? Is there anyway we can find it out using TSQL? I found some info on WMI but I have not used it before and do not know how.

    Try this:

    select name from sys.dm_os_loaded_modules

    where right(name,12) = 'sqlservr.exe'

  • July 2, 2009 at 12:39 pm

    #1019398

    Cool.. Worked for me. Thank you.

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

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