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 |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2008-02-26 : 11:04:58
|
| Hi experts,I am upgrading my database from SQL Server 2000, SP4 to SQL server 2005, SP2. 1) Is it required to recreated my user defined functions? I mean drop them and recreate them again?2) Do I need to recreate the views and Stored procedure?3) Do we have a checklist from Micorosoft for upgradation?Thanks in advanceRegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-26 : 11:20:16
|
| Depends on the compatibility you choose after upgrading:If you choose 80: you won't be able to have new functionality of 2005If you choose 90: you won't be able to have new functionality of 2000But you don't need to rewrite the code |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-26 : 15:17:40
|
| There is an Upgrade wizard , run it and it will give you lists of issues to consider.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
Is it needed?