baxleys.org » nate

Code that will search Triggers, Stored Procs, and Functions in MS SQL Server

Search across the text of all stored procedures for a particular string.

When you are returning longer text, like from a varchar(MAX) or such you get weird characters at the end.

Search and replace all occurances of a string in all tables in a database. From http://vyaskn.tripod.com/ --To replace all occurences of 'America' with 'USA': EXEC SearchAndReplace 'America', 'USA' GO

Search all text fields across all tables in a database.  Taken from http://vyaskn.tripod.com/ --To search all columns of all tables in Pubs database for the keyword "Computer" EXEC SearchAllTables 'Computer' GO

Here's a sample of some code to update a date field in MS SQL Server using a trigger.