返回
-
标题
Compiling the database with certain database users causes "Database error 50000: re-throw in Procedure vid_FillDialogCustomSQL". -
说明
We configured an additional DB user according to the minimal SQL permissions guide, but when trying to compile the database with the additional DB user, we see the error message "Database error 50000: re-throw in Procedure vid_FillDialogCustomSQL". -
原因
When compiling the database, stored procedures are executed and rolled back. The error message is thrown when executing a stored procedure, e.g. a customer stored procedure, fails. This could have various reasons, such as lack of permissions. E.g. the procedure has a bulk load statement and the DB user used for the compilation does not have bulkadmin permissions. -
解决办法
Use an SQL tool such as SQL Management Studio or Toad for SQL Server to try to execute the stored procedure within a transaction that you can roll back. If there are any errors, investigate them further.