October 24, 2010 at 11:10 am
Hi, i have a requirement where i need to delete some columns in a table ,i need to identify different stored procs affected by deleting this column and modify them.
can somebody give me tips in modifying the stored procedures.
thanks in advance
navin
October 24, 2010 at 11:23 am
Query sys.dm_sql_referenced_entities, or do wildcard searches through sys.sql_modules to find affected procs
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2010 at 2:35 pm
If I'm correct, datadude (visual studio for DBA) has that functionality, in case you're searching for other means than sql itself.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 25, 2010 at 10:06 am
Also look up the following in Books Online:
ALTER PROCEDURE
CREATE PROCEDURE
DROP PROCEDURE
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply