>What are the issues related to migrating stored procedures and user-defined functions from SQL 2000 to SQL 2005? Is there a good reference on this to which someone could point me?
>
>It looks like embedded comments prefixed with -- will no longer work in SQL 2005. Also, it looks like there may be some additional issues related to referencing objects (dbo. prefixes, etc). I'm trying to support someone remotely who's taken over some of my code on a secure network.
>
>Thx in advance.
All from SQL Server 2005 must work on SQL Server 2005.
I have DB created and managed with SQL Server 2000, I backup and restore it on my home computer where I have only SQL Server 2005 Developer installed and this DB works w/o any problems. All inline comments works, All SPs works, all dbo. prefixes works.
T-SQL is the same (much enhanced, but old code should work)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.