T-SQL Tutorial

Msg 15250 Level 16 - The database name component of the object qualifier must be the name of the current database


On Transact SQL language the Msg 15250 Level 16 - The database name component of the object qualifier must be the name of the current database.

This means that the database name is misspelled or the database does not exist.

Msg 15250 Level 16 Example:

Invalid statement:

USE model;
GO
EXEC sp_table_privileges
@table_name = 'students',
@table_owner = 'dbo',
@table_qualifier = 'model3432';

Message
Msg 15250, Level 16, State 1, Procedure sp_table_privileges, Line 17
The database name component of the object qualifier must be the name of the current database.

Correct statement:

USE model;
GO
EXEC sp_table_privileges
@table_name = 'students',
@table_owner = 'dbo',
@table_qualifier = 'model';

Other error messages: