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?
Thanks
Thanks
Last Comment
ASKER
OK,
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....
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....
refer link for sql trace
http://msdn.microsoft.com/en-us/library/ms191006.aspx
http://msdn.microsoft.com/en-us/library/ms191006.aspx
Try the query:
sp_who2
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.
sp_who2
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Nothing
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.