MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Lost ability to retrieve the schemes from MSSQL once we replaced our MSSQL 2008 R2 version with 2017 version
Posted by: Milosz Bodzek
Date: February 23, 2018 06:34AM

Hi Jacob,
Can you please execute some SQL stamenets on MS SQL Server and paste results here?
Firs one is:

exec sys.sp_databases

and second:

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;

Thanks,

--
Milosz Bodzek
MySQL Developer Tools

Options: ReplyQuote


Subject
Written By
Posted
Re: Lost ability to retrieve the schemes from MSSQL once we replaced our MSSQL 2008 R2 version with 2017 version
February 23, 2018 06:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.