Database
Special database object can not be located?

Answer Question   |  January 9, 2013  11:09 AM
Database, Database objects

Is there a query to search text of all SQL Server database objects that reference a specific table/instance?
We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

Answer Question   |  May 9, 2013  3:49 PM
Database objects, Query, SQL Server migration