September 17, 2009 at 12:23 am
Hi All,
I am in the process of upgrading a third part database from SQL 2k to SQL 2k5. Is there any query that works in SQL 2k but not working in SQL 2k5? I know one of them is non-ANSI left outer join *=. Is there anything else that I might need to look out for?
Thanks
September 17, 2009 at 2:56 am
start with the Upgrade advisor for sql2005 !
It will point you to potential issues with your db.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 17, 2009 at 3:02 am
Just to add to what ALZDBA said (which is what you should do first), I did find this document handy when I was doing the upgrade.(Its from MSDN) . I think you can find some information related to t-SQL queries in the section 3.03: Upgrading Transact-SQL queries.
lemme know if this helps. thanks.
---------------------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply