[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

I have an unknown sql database and I need to know what application it belongs too.

What query can I run to determine what application is using this database if any? Or what application created the database?

1 Solution
sql trace and you can see what's connecting to that database from where.
Name off database, the tables it contains .... can also tell you a lot. Or the users that have been granted access.

And if not ... prevent the database off being used (read only, offline ....) and wait for the errors and people to complain.  But that's not a nice way to do if you realy don't have a clue if it's important and when it's on production.
slmcculloughAuthor Commented:

So, what type of query can I run against the database that will give me the information I need inside the table or tables? Or even the headings... The dbo owner is the same for all the databases. It seems to be some type of archiving but really not sure.

Any ideas (or suggestions) of queries I can run to help me figure this out would be great. Like: what application created it? Or when was the last time it changed something? Whatever it is...it has created several of the same kind of databases but in increments of _01, _02, _03 and etc...

Thanks for any inputs....
Ramkisan JagtapLead DeveloperCommented:
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Daniel WilsonCommented:
Try the query:


That will tell a lot about what application & login are connecting to what databases.  Beyond that, jogos is right -- SQL Profiler will show you a lot.  Maybe more than you need to see, depending on activity levels.  But ... you might just watch the Login activity in SQL Profiler.  That might tell you enough.
exec sp_helpdb -> tells you when db's are created

In management studio you can open the database, see which tables are in it and even show the content of that table.

slmcculloughAuthor Commented:

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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