Changes in Error Numbers

Error message numbers have changed and new messages have been added. Applications that perform checks on message numbers need to also check for the new error message numbers. The permission failures described in this table include:

Those permissions set with the grant command
Permissions that depend on roles (such as sa_role or SSO_role) or on status as the DBO (database owner)

Pre-11.5.1 error number	Changed to:	Type of message
174	10312	Permission failure on built-in ad hoc audit function call
229	10330 567	Object permission failure; sp_loaddbupgrade role failure sp_addlanguage, sp_setlangalias role failure
230	10332	Column permission failure
259	10321	Ad-hoc updates to system tables not enabled
262	10302, 10331	Permission failure for setuser command
567	10353 10314	Permission failure for shutdown command Permission failure for sp_password
573	10317	Password too short in sp_addlogin
574	10316	Password is the same as previous password in sp_password
916	10302 10351	Permission failure for dump database command User is not a valid user in the database
1915	10304	Permission failure for create index command
2557	10304	Permission failure for dbcc commands
2563, 2564, 2565, 2567	10302	Permission failure for dbcc commands
2571	10353	Permission failure for dbcc commands
2710	10304	Permission failure for create, alter, truncate, update statistics, or bulk insert commands on a table
3004	10302	Permission failure for dump database command
3110	10302	Permission failure for load database command
3704	10302 10304	Permission failure for drop database command Permission failure for drop default command
4220	10302	Permission failure for dump transaction command
4312	10302	Permission failure for load transaction command
4602	10353	Permission failure of grant create database command
4603	10302	Permission failure of grant or revoke command
4710	10304	Permission failure for truncate table command
4910	10304	Permission failure for alter table...add column command
4931	10321	Permission failure for alter table...add column command on a system table
5011	10302	Permission failure for alter database command
5116	10353	Permission failure for disk mirror
6102	10353	Permission failure for kill command
7620	10311	Failure of attempt to change audit options manually.
7729	11105	Failure for set role commands; new message indicates a non-existent role
7730	10319	Failure for set role commands; new message indicates that the role is not granted to the user
7731	10320	Failure for set role commands; new message indicates that the role is not granted to the user in current database
7964	10302	Permission failure for dbcc commands
7983	10354	Permission failure for sp_procxmode
9503	10353	Role required message.
9902	10353	Permission failure for dbcc commands
17461	567	Permission failure for sp_remap