Link to download the first copy of PC Pro from 1994:
http://ads.dennisnet.co.uk/PC-Pro-first-issue.pdf
Back to the world of COM, 32 Bit OS, OS/2 and Parallel ports
How to search a MS-SQL DB for text in a stored procedure (updated)
Looking for a column that’s directly referenced by a stored procedure (sproc) then try running this query:
SELECT SProcName = OBJECT_NAME(object_id), Definition
FROM sys.sql_modules WHERE definition LIKE '%SEARCH_CRITERIA%'
ORDER BY SProcName;This replaces the previous post.
Important
If using MS SQL Server Management Studio 17+ then you need to make sure that the following option is checked:
Tools>Options>Query Results>SQL Server>Results to Grid>Retain CR/LF on copy or save
Otherwise carriage returns are lost. After checking the option you need to restart SSMS, for it to take effect on any queries.
TreaclePumpkin 