SQL Server Performance

SQL Server usage by a third party program

Discussion in 'SQL Server 2008 General DBA Questions' started by serdardmrk, Jul 20, 2009.

  1. serdardmrk New Member

    Hi guys,
    Is there any way to find out if the sql server is used by a third party program (such as ms office ...) please?
    Any suggestions appreciated.
    Thanks,
    serdardmrk, Jul 20, 2009
    #2

  2. Luis Martin Moderator

    Welcome to the forums!
    Yes, run Profiler and add Application Name column.
    Luis Martin, Jul 20, 2009
    #3

  3. serdardmrk New Member

    Thanks Luis, I'll give it a try. Are you aware of any T-SQL way of finding it?
    serdardmrk, Jul 20, 2009
    #4

  4. Luis Martin Moderator

    Yeap, sp_who2 give you ProgramName column.
    Luis Martin, Jul 20, 2009
    #5

  5. serdardmrk New Member

    I have two sql servers on the network which I cannot connect through SQL Server Management Studio or profiler with the known username and passwords of ours (Although they are available on the network connections list). When I logon to the windows server I can see SQL Server Service Manager running on both and only system databases in the ms sql data directory. I am just trying to find out if this SQL Server Service Manager running for notting and if the ms sql is not used by any third party program so I can uninstall it from the windows server box.
    Above suggestions will solve %80 of my problem but only these two.
    Thanks a lot for the help.
    Regards,
    serdardmrk, Jul 20, 2009
    #6

Share This Page