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 |
|
joni
Yak Posting Veteran
50 Posts |
 Posted - 2006-12-12 : 13:33:48
|
| Hi Gurus,I would like to know how can I do to compile Stored Procedures in SQL Server 2000?Thank very muchJoni |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-12 : 13:39:14
|
| Just run the Stored Procedures script in Query Analyzer.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2006-12-13 : 10:06:30
|
| Or sp_recompile 'procedure_name' |
|
|
|
|
|
|
Compile Procedures