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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slmcculloughAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

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.