Chandra Bhushan Prasad

DotNetOpenAuth is a well established open source library that bring OpenID, OAuth, and ICard capabilities to the Microsoft .NET Framework.

----Option 1 SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id = so.id WHERE sc. TEXT LIKE '%tablename%' ----Option 2 SELECT DISTINCT o.name , o.xtype FROM syscomments c INNER JOIN sysobjects o ON c.id = o.id WHERE c. TEXT LIKE '%tablename%'

declare @s varchar(8000) select @s=coalesce(@s +',"' ,'"') + ProjectName +'"' from ProjectMaster select @s