August 30, 2007 at 11:09 pm
Hello everybody,
We are migrating our project from SQL 2000 to SQL 2005, While doing so we are facing an issues when *= is used instead of left outer join in a view. When we replace *= with left outer join it works fine.
Why this strange behaviour? please help me out from this.
Please tell me what are the anticipated errors while migrating from 2000 to 2005 SQL
Thanks
Stephen
August 31, 2007 at 1:37 am
This "strange behaviour" is actually just as intended. The =* syntax has been deprecated a long time and in SQL 2005 only it's no longer supported.
To avoid problems like this the easiest way is to let the Upgarde Advisor analyse you databases before upgrading. The Help for Upgarde Advisor contains hundreds of possible issues during or after upgrade. I would never upgrade a server without first using this tool.
Markus
[font="Verdana"]Markus Bohse[/font]
August 31, 2007 at 1:01 pm
Thanks Buddy,
Added to your point, Please go through the below give Microsoft Article.
FIX: Error messages when you run a query that references a view in SQL Server 2005 Service Pack 2: “A severe error occurred on the current command. The results, if any, should be discarded”
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply