Search GETDATE() Function in Sql Server

Search GETDATE in All stored procedure and function

[sql]
SELECT DISTINCT
o.name AS Object_Name
,o.type_desc
,LEFT(m.definition,500) AS def
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id = o.object_id
WHERE m.definition LIKE '%GETDATE%' ESCAPE '\'
[/sql]


Search GETDATE in Default value on tables

[sql]
SELECT
table_schema
,table_name
,COLUMN_NAME
,column_default
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_default LIKE '%GETDATE%' ESCAPE '\'
ORDER BY
table_schema
,table_name
[/sql]

Search GETDATE in Computed column formula on tables

[sql]
SELECT
a.definition
,a.name
,b.name
FROM sys.computed_columns a
INNER JOIN sys.tables b ON a.object_id = b.object_id
WHERE definition LIKE '%GETDATE%' ESCAPE '\'
[/sql]