Re: Lost ability to retrieve the schemes from MSSQL once we replaced our MSSQL 2008 R2 version with 2017 version

[Jacob Nikom]

Hello Milosz,

Thank you for looking into my case.

Here are the results of the queries on SQL Server 2017 running on Windows
Server 2016 operating system you asked me to execute (I formatted the
SQL Server output a little bit to make it look more like MySQL output.
You have to use fixed width font to see the formatting.)

1.
SELECT TABLE_SCHEMA AS SCHEMANAME, max(TABLE_CATALOG) AS CATALOGNAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_CATALOG = 'put_here_catalog_from_previous_query'
GROUP BY TABLE_SCHEMA
UNION
SELECT ROUTINE_SCHEMA AS SCHEMANAME, max(ROUTINE_CATALOG) AS CATALOGNAME
FROM INFORMATION_SCHEMA.ROUTINES
GROUP BY ROUTINE_SCHEMA;
+------------+--------------+
| SCHEMANAME | CATALOGNAME |
+------------+--------------+
| dbo | rfcAnalysis |
+------------+--------------+
(1 row affected)

2.
exec sys.sp_databases;
+--------------+---------------+---------+
| DATABASE_NAME| DATABASE_SIZE | REMARKS |
+--------------+---------------+---------+
| | | |
+--------------+---------------+---------+

In the second query the output was empty (nothing).

Best regards,

Jacob Nikom