Solved

Can I use SQL Profiler on SQL Express DB

Posted on 2011-03-02
2
378 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

630 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