June 6, 2012

sp_oledb_deflang (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_oledb_deflang()

MetaData:

   
create procedure sys.sp_oledb_deflang
as
if serverproperty('EngineEdition') = 5
begin
if db_name() <> N'master'
begin
raiserror(40634,-1,-1)
return
end

EXEC('
select
ISNULL(default_language_name,'
'us_english'')
from
sys.sql_logins
where
sid=SUSER_SID()'
)
end
else
begin
EXEC('
select
ISNULL(language,'
'us_english'')
from
master..syslogins
where
sid=SUSER_SID()'
)
end

No comments:

Post a Comment

Total Pageviews