MS SQL Server – Search all columns of all tables in a database

Test Environment: MS Server 2008

For example to search all columns of all tables in Pubs database for the keyword “Computer”