Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    10

    Unanswered: Moving from MySQL - question

    Hello,

    I recently moved from MySQL (after 1 year of experience) to MS SQL Server as my company moved from MySQL to MS SQL Server so I am in the learning stage.

    I just wanted to know how you start up logging in SQL Server. I mean I want to log all the queries that are being executed against the server. I dont mean the binary logs but Actual query logging. Since I will be the admin I want to queries executed against all the databases.

    Is it possible?

    Regards
    Karam

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    From a given machine (to trace only that machine's queries) you can use the ODBC Trace. If you want to see all the query traffic reaching the server, you can use SQL Profiler.

    -PatP

  3. #3
    Join Date
    Mar 2004
    Posts
    10
    Thanks.

    Its late night in India, I will look it up tomorrow and get back if I face any problems.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Whew! I'll say it is late night for you.

    We get lots of questions from people with Asian names that may be just down the street. I didn't think you were actually located in India!

    Good night!

    -PatP

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Get a book Inside SQL Server 2000 by Kalen Delaney which is a good resource and best to start with for a newbie.

    And few unleased series from Techmedia too.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •