Devart Forums

Hello

Regarding

While trying to do initial commit I get the following error:

Error The SELECT permission was denied on the object 'sql_expression_dependencies', database 'mssqlsystemresource', schema 'sys'. Source Control: Myproject(Mydatabase.database.windows.net) 1

My database is an Azure SQL single database. I have root privileges but I also have tried with other users/logins without success.

I also have searched forum for answers, but the common suggestions do not help. IE I have tried the following to by example user 'dbdeveloper'

EXEC sp_addrolemember N'db_datareader' ,N'dbdeveloper'
GRANT SELECT ON sys.sql_expression_dependencies TO dbdeveloper

I still get the same error. So what spells should I cast to get this to work?

Could you please provide us the full name of the product and its version?

Also, please install dbForge Studio for SQL Server, Enterprise Edition that includes the logging functionality https://www.devart.com/dbforge/sql/studio/download.html and perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce the issue and send us the *.log file with the latest date from the directory: You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

Version: dbForge Source Control for SQL Server 2.0.196
Standard edition

Thank you for the reply.

We will investigate this issue and will answer you as soon as possible.

We have sent you a custom build with the fix by e-mail.