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 |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2007-12-19 : 15:28:02
|
| Is there a way (command or stored procedure) to RECOMPILE or REFRESH a USER DEFINED FUNCTION? I can recompile SPs with sp_recompile and refresh views with sp_refreshView, but I could not find any way to refresh User-defined functions (some of them are like views, with parameters).Environment: SQL 2005 SP2.Thanks ! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-19 : 15:39:26
|
| Checked sp_refreshsqlmodule? |
 |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2007-12-19 : 20:04:18
|
| Is there anything in SQL 2000 SP 4?Thanks ! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-19 : 20:46:39
|
| Maybe not, double check sql2k books online. |
|
|
|
henrikop
Constraint Violating Yak Guru
280 Posts |
Posted - 2008-01-14 : 05:03:00
|
| sp_refreshsqlmodule is cool! Anyone has written a script already to refresh entire database?Henri~~~~There's no place like 127.0.0.1 |
|
|
|
|
|
|
RECOMPILE / REFRESH UDF?