How to find a text inside SQL Server procedures / triggers?

1) Search in All Objects

This script search stored procedures, views, functions as well other objects.
-- Search in All Objects
SELECT OBJECT_NAME(OBJECT_ID),
definition
FROM sys.sql_modules
WHERE definition LIKE '% iID %'
GO

2) Search in Stored Procedure

This script search only stored procedure for specified column.
-- Search in Stored Procedure Only
SELECT DISTINCT OBJECT_NAME(OBJECT_ID),
object_definition(OBJECT_ID)
FROM sys.Procedures
WHERE object_definition(OBJECT_ID) LIKE '% iID %'
GO

Assign Value to Asp.Net TextBox with mode=”Password”

 Using ASP.NET, the default textbox in password mode (TextMode="Password") has the following restrictions:

• The password can not be set (e.g., tbPassword.Text = "ThePassword";)
• The password is not restored after a postback

Both restrictions make perfect sense for security reasons. Nonetheless, sometimes the above behaviour is not wanted (especially during development).

The new PasswordTextBox control is an extension of the standard ASP.NET TextBox and makes a password textbox behave like a regular textbox.

PasswordTextbox.Attributes.Add("value", "ThePassword");

Use this to set the value, instead of setting the Text Property.

Find a table knowing a column name

  Exactly know the column name,

• SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'YOURCOLUMN' 

  if you're unsure exactly what the column is named,but you suspect you know part of the
  name, then try...

• SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME  like  '%YOURCOLUMN%'