sp_droplanguage System Stored Procedure

Drops an alternate language from the server and removes its row from master.dbo.syslogins.

Syntax

sp_droplanguage language [, dropmessages]

where

language: Is the language to be dropped.
dropmessages: Drops all SQL Server system messages in language when the language is dropped. A language with associated system messages cannot be dropped without also dropping its messages.

Remarks

Executing the sp_droplanguage system stored procedure also drops a language from the list of available alternate languages by deleting its entry from the master.dbo.syslanguages table.

Examples

A. Drop a Language

If there are no associated messages, this example drops French from the set of available alternate languages.

sp_droplanguage french

B. Drop a Language with Messages

If there are associated messages, this example drops French from the set of available alternate languages.

sp_droplanguage french, dropmessages

Permission

Only the system administrator can use this procedure.

Tables Used

master.dbo.syslanguages, master.dbo.sysmessages