Reports information about a particular alternate language or about all languages.
sp_helplanguage [language]
is the name of the alternate language for which to display information about.
Displays information about the alternate language, “french”:
sp_helplanguage french
langid dateformat datefirst upgrade name alias months shortmonths days ------ ---------- --------- ----------- ----------------------- ---------------------------- ----------------------------------------------------------- ----------------------------------------------------------- ----------------------------------------------------------- 1 dmy 1 0 french french janvier,février,mars,avril,mai,juin,juillet,août,septembre, octobre,novembre,décembre jan,fév,mar,avr,mai,jui,juil,aoû,sep,oct,nov,déc lundi,mardi,mercredi,jeudi,vendredi,samedi,dimanche
Displays information about all installed alternate languages:
sp_helplanguage
sp_helplanguage reports on a specified language, when the language is given, or on all languages in master.dbo.syslanguages, when no language is supplied.
Any user can execute sp_helplanguage.
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_droplanguage, sp_setlangalias
