Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2007-07-18 : 08:28:43
|
| Hello All, Is it possible in sql to find out that 'Among the large no of stored procedures in database where the a particular column of table is updated and the name of the stored procedure in which column is updated?' for example .I want to search where from n number of stored procedures where the 'flag' field is updated to true' if yes how it is possibe (I can view the object dependencies for stored procedure or table ,is it possible for viewing object dependencies for column of table?) |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-18 : 10:01:59
|
When I have a problem like this, I do one of two things:1. script out all procs, and then search them with my favorite code editor. this will script out everything for you: http://www.codeplex.com/scriptdb2. generate a chm for the database using sqlspec, and then search the chm (it's indexed) for all pages containing the text you seek. this is very handy. see the link in my sig for a free copy of sqlspec.hth
elsasoft.org |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-07-18 : 10:15:28
|
quick and dirtyselect Routine_namefrom information_schema.routineswhere routine_definition like '%your column name%'and routine_definition like '%update%' Then you can look in that list to see if your column is being updated.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
finding the sp where the 'flag' field is updated