Using Microsoft SQL Profiler to trace installation program

Posted on 2005-05-17
Last Modified: 2010-03-19
I want to view the trace for the Microsoft Business Scorecard Accelerator Installation program, that creates a database in SQL Server.

I followed the instructions in this tutorial:

But still I'm unable of getting any trace information for the installation.

This question is a follow-up to the problem specified at:

best regards,

Question by:henrikatwork
    LVL 13

    Expert Comment

    1. Start SQL Server Profiler:
    "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\profiler.exe"
    2. Use standard template (do not change anything - use default)
    3. Click on RUN
    LVL 1

    Author Comment

    that's exactly what I did, but I only get to see anything except TraceStart :(

    LVL 13

    Accepted Solution

    If your database if used by multiple users:
    1. Stop trace
    2. Identify information specific for installation program: It can be Username,AppName,HostName or a combination.
    3. Open New trace window
    4. Click on Filter tab and define filters for installation program from step 2
    5. Start trace

    Installation monitoring:
    6. Start installation
    7. After installation error, stop trace.
    8. Mark all trace rows
    9. Click trace detail on the bottom
    10. Press Control+A,Control+C
    11. Start isqlw and login, press Control+V
    12. Run query
    13. See errors
    LVL 13

    Expert Comment

    >>>that's exactly what I did, but I only get to see anything except TraceStart :(
    Go to Events tab and add Cursors events.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    Title # Comments Views Activity
    SQl server DB permission questions 3 35
    Not selecting duplicate data 6 21
    Barracuda Bsckup Server 690 6 48
    Delete from table 6 26
    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now