Converting SQL2000 database to SQL2005

Are there any stored procedures that have to be run on a database when
restoring from SQL2000 to SQL 2005? If so, which ones?
Many Thanks!No. But you should probably run the Upgrade Advisor (found on the SQL 2005
distribution media) before moving the database over, in order to ensure that
at least most of your code is compatible (the Advisor won't find
everything).
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Steve" <stevex2@.directcon.net> wrote in message
news:CD8A547F-7754-4FBB-9B6E-29C3B4AECB5C@.microsoft.com...
> Are there any stored procedures that have to be run on a database when
> restoring from SQL2000 to SQL 2005? If so, which ones?
> Many Thanks!|||And also up date compatibility mode when you are ready for it (see sp_dbcmptlevel).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
news:53A849D2-97E5-4ACE-A1DB-5EFC798026AF@.microsoft.com...
> No. But you should probably run the Upgrade Advisor (found on the SQL 2005 distribution media)
> before moving the database over, in order to ensure that at least most of your code is compatible
> (the Advisor won't find everything).
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Steve" <stevex2@.directcon.net> wrote in message
> news:CD8A547F-7754-4FBB-9B6E-29C3B4AECB5C@.microsoft.com...
>> Are there any stored procedures that have to be run on a database when
>> restoring from SQL2000 to SQL 2005? If so, which ones?
>> Many Thanks!
>