sql + mssql

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

Long character fields from database weird in PHPWhen you are returning longer text, like from a varchar(MAX) or such you get weird characters at the end.

Search and Replace All TablesSearch 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 TablesSearch 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