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.
- IEXPSYS
- SYSVT
- TELDATAAPP
- 0101CONSTRUCAPP
but I don't know wich data can make the filter to get by type (system or application)
I need this result:
System:
- IEXPSYS
- SYSVT
Application:
- TELDATAAPP
- 0101CONSTRUCAPP
Thanks vey much
Greetings.