Search trough all database and stored procedureS and views for a specific word.

USE master
GO
-- FIND COLUMN 
DECLARE @FindColumn NVARCHAR(128) = '<COLUMN TO SEARCH FOR>'
-- PRINT DYNAMIC SQL STATEMENT INSTEAD OF EXECUTING IT
DECLARE @Debug BIT = 0
-- CRAETE TEMP TABLE TO STORE THE RESULT
CREATE TABLE #SearchResult (DbName SYSNAME, ObjectName SYSNAME, ObjectType SYSNAME)

-- DYNAMIC SQL SETTINGS
DECLARE @parm NVARCHAR(41)
SET @parm = '@FindColumn nvarchar(128)'
DECLARE @SQL NVARCHAR(MAX)
SET @SQL = 'exec sp_msforeachdb ''use [?];
SELECT 
 DbName =  ''''?''''
,ObjectName = obj.name
,ObjectType = obj.type
FROM sys.syscomments sc
INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID
WHERE sc.TEXT LIKE ''''%'+@FindColumn+'%'''' escape ''''['''''''

IF @Debug =1 
BEGIN
    PRINT @SQL
END ELSE

INSERT INTO #SearchResult (DbName, ObjectName, ObjectType)
EXEC SP_EXECUTESQL @SQL, @PARM, @FindColumn

SELECT * FROM #SearchResult
DROP TABLE #SearchResult
GO

Enable all alerts

SELECT 'exec msdb..sp_update_alert @name = '''+NAME+''', @enabled = 1' 
FROM MSDB..SYSALERTS

Disable all alerts

SELECT 'exec msdb..sp_update_alert @name = '''+NAME+''', @enabled = 0' 
FROM MSDB..SYSALERTS

CREATE TABLE #identity_columns
(   [database_name] SYSNAME NOT NULL,
    [schema_name] SYSNAME NOT NULL,
    table_name SYSNAME NOT NULL,
    column_name SYSNAME NOT NULL,
    [type_name] SYSNAME NOT NULL,
    maximum_identity_value BIGINT NOT NULL,
    current_identity_value BIGINT NULL,
    percent_consumed DECIMAL(25,4) NULL );

DECLARE @Table_Name NVARCHAR(MAX);
DECLARE @Schema_Name NVARCHAR(MAX)
DECLARE @Sql_Command NVARCHAR(MAX) = '';

SELECT @Sql_Command = @Sql_Command + '
INSERT INTO #identity_columns
    ([database_name], [schema_name], table_name, column_name, [type_name], maximum_identity_value, current_identity_value)
SELECT
    DB_NAME() AS database_name,
    ''' + schemas.name + ''' AS schema_name,
    ''' + tables.name + ''' AS table_name,
    ''' + columns.name + ''' AS column_name,
    ''' + types.name + ''' AS type_name,
    CASE
        WHEN ''' + types.name + ''' = ''TINYINT'' THEN CAST(255 AS BIGINT)
        WHEN ''' + types.name + ''' = ''SMALLINT'' THEN CAST(32767 AS BIGINT)
        WHEN ''' + types.name + ''' = ''INT'' THEN CAST(2147483647 AS BIGINT)
        WHEN ''' + types.name + ''' = ''BIGINT'' THEN CAST(9223372036854775807 AS BIGINT)
        WHEN ''' + types.name + ''' IN (''DECIMAL'', ''NUMERIC'') THEN CAST(REPLICATE(9, (' + CAST(columns.precision AS VARCHAR(MAX)) + ' - ' + CAST(columns.scale AS VARCHAR(MAX)) + ')) AS BIGINT)
        ELSE -1
    END AS maximum_identity_value,
    IDENT_CURRENT(''[' + schemas.name + '].[' + tables.name + ']'') AS current_identity_value;
'
FROM sys.tables
INNER JOIN sys.columns
ON tables.object_id = columns.object_id
INNER JOIN sys.types
ON types.user_type_id = columns.user_type_id
INNER JOIN sys.schemas
ON schemas.schema_id = tables.schema_id
WHERE columns.is_identity = 1;

EXEC sp_executesql @Sql_Command;

UPDATE #identity_columns
    SET percent_consumed = CAST(CAST(current_identity_value AS DECIMAL(25,4)) / CAST(maximum_identity_value AS DECIMAL(25,4)) AS DECIMAL(25,2)) * 100;

SELECT
    *
FROM #identity_columns;