?
Solved

Using Microsoft SQL Profiler to trace installation program

Posted on 2005-05-17
4
Medium Priority
?
276 Views
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:
http://www.developer.com/db/article.php/3482216

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

This question is a follow-up to the problem specified at:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21425479.html

best regards,

henrik
0
Comment
Question by:henrikatwork
  • 3
4 Comments
 
LVL 13

Expert Comment

by:ispaleny
ID: 14017479
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
0
 
LVL 1

Author Comment

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

0
 
LVL 13

Accepted Solution

by:
ispaleny earned 1000 total points
ID: 14017519
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
0
 
LVL 13

Expert Comment

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

840 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