T-SQL to Rename a Column Name or Table Name

renaming any column :
sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

renaming any object (table, stored procedure etc) :
sp_RENAME '[OldTableName]' , '[NewTableName]'

Links to free web sniffer applications

Microsoft Network Monitor
http://www.microsoft.com/en-us/download/details.aspx?id=4865

Fiddler
http://www.fiddler2.com/fiddler2/

HttpWatch
http://www.httpwatch.com/download/

HTTP Response Status Code Group

1xx: Informational. The request was received and server is continuing to process.
2xx: Success. The action was successfully received, understood and accepted.
3xx: Redirect Command. The client must access a different resource.
4xx: Client Error. The server does not know how to fulfill the request. The request may have syntax error.
5xx: Server Error. The server failed to fulfill the request that appears to be valid.

Use sp_refreshview to refresh view

When a table schema is updated the view does not update on its own.

sp_refreshview updates metadata of the specified view

To update a specifiec view

EXECUTE sp_refreshview '[VIEWNAME]'

To update all views that are dependent on a specified object

SELECT DISTINCT 'EXEC sp_refreshview ''' + name + ''''
FROM sys.objects AS so
INNER JOIN sys.sql_expression_dependencies AS sed
ON so.object_id = sed.referencing_id
WHERE so.type = 'V' AND sed.referenced_id = OBJECT_ID('[OBJECTNAME]');

Get List of All Triggers in a Database

SELECT trigger_name = name, trigger_owner = USER_NAME(uid), table_name = OBJECT_NAME(parent_obj),
isupdate = OBJECTPROPERTY( id, 'ExecIsUpdateTrigger'), isdelete = OBJECTPROPERTY( id, 'ExecIsDeleteTrigger'),
isinsert = OBJECTPROPERTY( id, 'ExecIsInsertTrigger'), isafter = OBJECTPROPERTY( id, 'ExecIsAfterTrigger'),
isinsteadof = OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger'),
status = CASE OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') WHEN 1 THEN 'Disabled' ELSE 'Enabled' END
FROM sysobjects
WHERE type = 'TR'

Using Apply: CROSS APPLY and OUTER APPLY

The APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a query.

http://msdn.microsoft.com/en-us/library/ms175156.aspx

CRL Table Valued Functions

http://msdn.microsoft.com/en-us/library/ms131103.aspx