I'm accessing the database (SQL server 2012) provided by a third party supplier. The product includes some views. When I query those views from SQL Server management studio everything is fine, apart from the horror the is SSMS, When I query those views from dbForge I get an "The EXECUTE permission was denied on the object 'functionName', .... " error.
The user is the same for both products.
I am baffled.
Different results in DBForge and SSMS
-
alexa
Re: Different results in DBForge and SSMS
Could you please 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.
6. Send us the *.log file with the latest date from the directory '%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\'.
You can send a reply straight to our support system at supportATdevartDOTcom
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.
6. Send us the *.log file with the latest date from the directory '%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\'.
You can send a reply straight to our support system at supportATdevartDOTcom