hello
I need to know how can i get all database applicaction and all databases systems installed on Dynamics SL 2011 by SQL query.
I make the query: "select * from sys.databases", and I get all databases installed on my server.
but I don't know wich data can make the filter to get by type (system or application)
I need this result:
System:
Application:
Thanks vey much
Greetings.
There's no single query to produce this. You've got to have some scripting or procedure as far as I know. This because of MSSQL design.
Having said so, there are some macro oriented sp built in SQL. The closest thing to a one liner may be something like:
sp_msforeachdb 'select distinct "?" AS dbsys, DatabaseName as dbapp from [?].dbo.Company'
This will produce sys database and app database matching pairs along with an awful lot of errors. If you are using SQL Mgmt Studio, set the outoput to text for beter results. Beware that we are not really scanning APP databases, they appear in the result because they are mentioned by SYS ones. In your case, the output would be something like:
Invalid object name 'TELDATAAPP.dbo.Company'. dbsys dbapp -------- ------------------------------ IEXPSYS 0101CONSTRUCAPP Invalid object name '0101CONSTRUCAPP.dbo.Company'. dbsys dbapp ------ ------------------------------ SYSVT TELDATAAPP
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,537
Super User 2024 Season 2
#2
Martin Dráb
228,520
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (