Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

What is using a MSSQL2005Express database

How can I tell what application is using a MSSQL2005Express database?  I have inherited computers that have this installed, but I don't see what application would be using it.
I'd like to uninstall it if it's not needed.
0
Andrew-T
Asked:
Andrew-T
  • 2
  • 2
1 Solution
 
strickddCommented:
Quick and dirty, unintall is and see what blows up.

More in-depth, take all the databases offline or stop the sql services in services.msc.
0
 
JestersGrindCommented:
If the names of the databases don't tell what their function is, you can run sp_who2 to see if there are any external connections to it.  Look at the HostName column to get the names of the machines connected to it.  If that doesn't help, you could always stop the SQL services for a while and see if anyone notices.

Greg

0
 
Andrew-TAuthor Commented:
Thanks for the tips
Two questions - Where do I find sp_who2 and how do I see what the database names are?
0
 
JestersGrindCommented:
You have to use SQL Server Management Studio for both.  It should be installed on the SQL Server.  To find the database names,  go to View --> Object Explorer.  Click on the connect button, connect to ServerName\SQLExpress using Window Authentication.   In Object Explorer, expand the databases folder to see the names of all of the databases.  Right-click on one of the databases and select new query.  Type sp_who2 in the window and click on the execute button or press F5.

Greg

0
 
Andrew-TAuthor Commented:
Thanks!
This got me in and I can see which application is using this installation of sql.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now