Home Forums SQL Server 2008 SQL Server 2008 - General Writing data to SQL from application server RE: Writing data to SQL from application server

  • September 2, 2014 at 5:02 pm

    #1742642

    Adi Cohn-120898 (9/2/2014)

    The profiler has the columns Application Name, Login Name and Host Name. You can use them to figure out from which application, login and machine any statement came from. You can also have a filter based on those columns.

    Adi

    Thanks for your response ! Appreciate it

    hmm I just run the sql profiler and I wonder there are some records that has no hostname ... but some others have it .

    Any idea why ?

    I am a bit suspicious the query that has no hostname comes from that application but not so sure yet