Skip to content

Instantly share code, notes, and snippets.

View remcok's full-sized avatar
💭
Typing...

Remco Koedoot remcok

💭
Typing...
  • Almere, Netherlands
View GitHub Profile
@remcok
remcok / scheduled task
Last active January 21, 2020 17:04
Scheduled task with powershell calling http resulting exit code
Add a scheduled task to Windows to execute the script "wake-up-http.ps1"
powershell -NonInteractive -NoLogo -NoProfile -Command ". C:\wake-up-http.ps1; Exit $LASTEXITCODE"
@remcok
remcok / gist:437556f043ced0eb3784
Created May 15, 2014 11:46
Query to find certain text used in sql server objects
-- Set search text
DECLARE @searchTerm varchar(MAX)
SET @searchTerm = '<SEARCH_TERM>'
-- Stored Procedures
SELECT OBJECT_NAME(M.object_id) as sp_name, M.*
FROM sys.sql_modules M
JOIN sys.procedures P
ON M.object_id = P.object_id
WHERE M.definition LIKE @searchTerm