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 28, 2018 09:05AM

Ok good, we can try two solutions:
1. fix exec sys.sp_databases;
Please take a look at Permissions section of https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-databases-transact-sql and verify that your user have all required permissions
2. we can try modify python code to use 'SELECT * FROM sys.databases;' insetad of exec sys.sp_databases, but only if point 1 fails

Reagrds,

--
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 28, 2018 09:05AM


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.