Isues aftre Migration from SQL2000 to SQL2005

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Isues aftre Migration from SQL2000 to SQL2005

Author

Topic

hemendravyas
Starting Member

1 Post

Posted - 2008-07-17 : 08:12:54

I have received following issues aftre migration (the DBA sent me the list for the information):
1. Remove references to undocumented system tables
Many system tables that were undocumented in prior releases have changed or no longer exist; therefore, using these tables may cause errors after upgrading to SQL Server 2005. Because Upgrade Advisor looks for references to system table names, it will report references to any user tables that have the same names as system tables.

2. Changes to behavior in syslockinfo and sp_lock
In SQL Server 2005, syslockinfo and sp_lock may return unexpected values, and may return multiple rows where previous versions of syslockinfo and sp_lock returned at most two rows. Also, in order to access information from syslockinfo or execute sp_lock in SQL Server 2005, the user must have VIEW SERVER STATE permission on the server.

3. Column aliases in ORDER BY clause cannot be prefixed by table alias
In SQL Server 2005, column aliases in the ORDER BY clause cannot be prefixed by the table alias.

Please help me with this as how to rectify the above. I have admin rights over the DB.

Regards,
Hemendra

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-17 : 08:18:29

Any questions? Everything looks obvious.

anandkumar.guna
Starting Member

2 Posts

Posted - 2011-10-20 : 08:04:34

I am also getting the same errors.

Please somebody post some answer to solve it. :)

Cheers,
Anandkumar.G

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources