text: IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[SQLCop].[test Auto Shrink]') AND type in (N'P', N'PC'))
  DROP PROCEDURE [SQLCop].[test Auto Shrink]
  GO
  
  CREATE PROCEDURE [SQLCop].[test Auto Shrink]
  AS
  BEGIN
  	-- Written by George Mastros
  	-- February 25, 2012
  	-- http://sqlcop.lessthandot.com
  	
  	SET NOCOUNT ON
  	
  	Declare @Output VarChar(max)
  	Set @Output = ''
  
      Select @Output = @Output + 'Database set to Auto Shrink' + Char(13) + Char(10)
      Where  DatabaseProperty(db_name(), 'IsAutoShrink') = 1
      
  	If @Output > '' 
  		Begin
  			Set @Output = Char(13) + Char(10) 
  						  + 'For more information:  '
  						  + 'https://blogs.msdn.microsoft.com/buckwoody/2009/07/01/sql-server-best-practices-auto-shrink-should-be-off/'
  						  + Char(13) + Char(10) 
  						  + Char(13) + Char(10) 
  						  + @Output
  			EXEC tSQLt.Fail @Output
  		End
  END;