MSSQL 2005 : Search Column name

Select O.name objectName, C.name ColumnName
from sys.columns C
inner join sys.objects O
ON C.object_id=O.object_id
where C.name like 'address1'
order by O.name,C.name

IIS error : Failed to access IIS metabase.

please follow step below to fix this issue

1. registered ASP.NET 2.0 with IIS using "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis –i"
2. Gave permissions to the ASPNET account using "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis –ga ASPNET"
   

Add running number to row

select row_number() OVER (ORDER BY key) as RunningN,* from TBLName

select rank() OVER (ORDER BY key) as RunningN,* from TBLName

Add new column to existing table

ALTER TABLE tbl1 ADD name varchar NOT NULL

Find any keywords in Stored procedure

SELECT Routine_Name, Routine_Definition
FROM Information_Schema.Routines
WHERE Routine_Definition Like '%tblname%'
AND Routine_Type = 'Procedure'