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 |
|
Emile Petrus
Starting Member
1 Post |
 Posted - 2011-10-26 : 19:51:29
|
| I need to refresh the dependencies of some database objects, like stored procedures, views and functions. The dependencies are lost when the objects are changed (example ‘alter view..’)For SQL Server 2005 SP2 and SQL 2008 databases I successfully use the procedure 'sp_refreshsqlmodule'.For SQL Server 2000 databases is only available the procedure 'sp_refreshview', which unfortunately only works for views.Is there a equivalent procedure in SQL Server 2000 (or any other way to update the dependencies)?Emile |
|
|
|
|
|
Replacement for sp_refreshsqlmodule in SQL2K