Recently one of my co-workers dropped me an IM asking how he could find what stored procedures depended on a certain table. After a little digging we came up with the following query which will return a listing of stored procedures that depend on a particular table (T_TableName). select distinct so.name from syscomments
Similar Posts
In order to use SQL cache dependencies in ASP.NET 2.0 on the Express Edition of SQL Server 2005 or on SQL Server 7.0 or 2000, ASP.NET needs to continuously
Praveen asks in one of the SQL Server aliases in Microsoft a question about an issue that us not very well understood HiLet me know if this is not a appropriate
Phil just posted about using INFORMATION_SCHEMA to bulletproof your SQL change scripts . I've been working up a post on using queries against INFORMATION_SCHEMA
I use stored procedures for a lot of the data access I do within the applications I develop. Overall I like using stored procedures for data access, however
