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:

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