How to list all Navision Databases on a SQL Server

h-d.neuenfeldt · January 21, 2014, 8:44pm

My Problem : I need a SQL Statement in form of :

Use (1)

Select name from (2) where (3)

1 I don’t know which systemdatabase to use

2 I don’t know which table includes the list of Navison-databases

3 how to set the condition ‘only navisiondatabases’

System : SQL 2012

h-d.neuenfeldt · January 23, 2014, 10:01am

i find my own way …

first i get a list of all databases

then i test the existing of [database].[dbo].[user]

then i test the existing of the user 'super" in [database].[dbo].[user]

if this all pased then a navison database ist found …

babrown · January 23, 2014, 11:27am

Of course, assuming you don’t have a database without a user called SUPER.

h-d.neuenfeldt · February 6, 2014, 7:44am

there ist also a way for databases without a user called “super”