Problem with upgrade from 80>82

The upgrade is trying to enable "nested triggers", it looks like you don't have sp_configure privileges.

EXEC sp_configure 'nested triggers', 1;
Try running the upgrade with a user that has the privilege (sa or other).

I will look at maybe implementing the feature with a different method (without recursion).


http://technet.microsoft.com/en-us/library/ms188787.aspx

Permissions
--------------------------------------------------------------------------------
Execute permissions on sp_configure with no parameters or with only the first parameter are granted to all users by default. To execute sp_configure with both parameters to change a configuration option or to run the RECONFIGURE statement, you must be granted the ALTER SETTINGS server-level permission. The ALTER SETTINGS permission is implicitly held by the sysadmin and serveradmin fixed server roles.

----------------

Best regards,

Stefane,

Is this something new from version .13?
I have not had any upgrade problems before.

Yes, the bug was introduced in the .13 will be fixed in the .14

Instead of asking for sp_configure permissions we changed our implementation to work regardless if 'nested triggers' is enable or not.