Using below query , you can fetch all objects SP/UDF/Views from db which uses specific word.
SELECT DISTINCT o.[name]
FROM sysobjects o
INNER JOIN syscomments c
ON (c.id = o.id)
WHERE xtype in (‘P’,’V’) and category = 0 AND c.[text]
LIKE ‘%wordd%’
Read article here..
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/viewstate.asp
In this article we examined the ASP.NET view state, studying not only its purpose, but also its functionality. To best understand how view state works, it is important to have a firm grasp on the ASP.NET page life cycle, which includes stages for loading and saving the view state. In our discussions on [...]
TOP Clause Enhancements in SQL Server 2005
TOP clause was a part of T-SQL for prior version of SQL Server 2005 but it was limited to SELECT statements and could be used with literal values. There were some techniques to make it dynamic using SET ROWCOUNT statement but SQL Server 2005 introduces some enhancements for this [...]
OUTPUT Clause in SQL Server 2005
In previous versions of T-SQL you had to use a trigger to retrieve data from inserted, updated or deleted rows in tables which wasn’t very straightforward. SQL Server 2005 adds a new clause to T-SQL to simplify this task. OUTPUT is this clause.
First suppose that I have a [...]
