codinglite

test from pastebin --All stored procedure and function 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 '\' --Default value on tables 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 --Computed column formula on tables 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 '\'

Code php

View process in sql server DECLARE @SPID INT ,@SQLScript NVARCHAR(max) SELECT @SQLScript = CAST(TEXT AS NVARCHAR(max)) FROM sys.sysprocesses sp CROSS APPLY sys.dm_exec_sql_text(sp.sql_handle) WHERE sp.spid = @SPID select @SQLScript How to use : Check running process from sp_who2, get sp_id run scrib to view detail process running. select * from [Sales].[Invoice.Vat.UpdateList] where convert(date,update_time)='2017-02-11'

Install Poor Mans T-SQL formatting add-in for Management Studio 2014, Master Poor Mans T-SQL from hire . Install Poor Mans T-SQL Create the folder : % SystemDrive %\ ProgramData \ Microsoft \ SQL Server Management Studio \ 12.0 \ Addins \ If it does not exist. Then just copy the file from: % SystemDrive %\ ProgramData \ Microsoft \ SQL Server Management Studio \ 11.0 \ Addins \ PoorMansTSqlFormatterSSMSAddIn . AddIn To :  % SystemDrive %\ ProgramData \ Microsoft \ SQL Server Management Studio \ 12.0 \ Addins \ PoorMansTSqlFormatterSSMSAddIn . AddIn Add Shortcut TSQL Tool --> TQS Formating Option set SSMS HotKey Global::F2 source : http://stackoverflow.com/questions/23303026/does-the-poor-mans-t-sql-formatting-add-in-for-management-studio-2012-work-in-ma