Solved

Can I use SQL Profiler on SQL Express DB

Posted on 2011-03-02
2
376 Views
Last Modified: 2012-08-14
On our server we have a full version of SQL Server 2008 and when I develop against that I am able to use SQL Profiler.  On my laptop I have SQL Server 2008 Express and miss the use of the profiler when away from our office.  Is there a way I can use the SQL Profiler on Express?
0
Comment
Question by:canuckconsulting
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Swapnil Piparia earned 500 total points
ID: 35016988
Hi canuckconsulting,

    You can profile SQL express 2005 / 2008 through below profiler.
http://sites.google.com/site/sqlprofiler/

Thanks,
netswap
0
 
LVL 25

Expert Comment

by:reb73
ID: 35016992
The express edition does not ship with an SQL Server Profiler.

You could get the development edition installed on your laptop (about 50USD) or use other similar opensource tools -

http://sites.google.com/site/sqlprofiler/
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

710 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