SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [SQLCop].[test Login Language]
AS
BEGIN
-- Written by George Mastros
-- February 25, 2012
-- http://sqlcop.lessthandot.com
-- http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/setting-a-standard-dateformat-for-sql-se
SET NOCOUNT ON
Declare @Output VarChar(max)
Declare @DefaultLanguage VarChar(100)
Set @Output = ''
Select @DefaultLanguage = L.Name
From Master.dbo.sysconfigures C
Inner Join Master.dbo.syslanguages L
On C.Value = L.LangId
And C.Comment = 'default Language'
Select @Output = @Output + Name + Char(13) + Char(10)
From master..syslogins
Where Language <> @DefaultLanguage
Order By Name
If @Output > ''
Begin
Set @Output = Char(13) + Char(10)
+ 'For more information: '
+ 'http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/setting-a-standard-dateformat-for-sql-se'
+ Char(13) + Char(10)
+ Char(13) + Char(10)
+ @Output
EXEC tSQLt.Fail @Output
End
END;
GO
|