Post reply

How can I get the system information???

  • July 7, 2005 at 9:02 pm

    #186575

    I am a student and want to know something about sqlserver.I need some information about sqlserver system,like the user and the sql which is being used and all the sql that has been used.

    thank you.

  • July 7, 2005 at 9:23 pm

    #572155

    Because SQL Server can support many users connecting at once, it sounds like you want to use the Profiler tool. You can track what each user is submitting and keep a log of it. The specific functions and DBCC commands otherwise only reveal the last statement or information returned. They don't track history. Profiler is your best bet.

    K. Brian Kelley
    @kbriankelley

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

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