Drops an alternate language from the server and removes its row from master.dbo.syslanguages.
sp_droplanguage language [, dropmessages]
is the official name of the language to be dropped.
drops all Adaptive Server system messages in language. You cannot drop a language with associated system messages without also dropping its messages.
This example drops French from the available alternate languages, if there are no associated messages:
sp_droplanguage french
This example drops French from the available alternate languages, if there are associated messages:
sp_droplanguage french, dropmessages
Executing sp_droplanguage drops a language from a list of alternate languages by deleting its entry from the master.dbo.syslanguages table.
If you try to drop a language that has system messages, the request fails unless you supply the dropmessages parameter.
The permission checks for sp_droplanguage differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage server privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. |
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_addlanguage, sp_helplanguage
