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.
| Author |
Topic |
|
asyssolvers
Starting Member
9 Posts |
 Posted - 2011-03-06 : 00:39:29
|
| Hi,.Hi I am having around 200-250 reports that are developed in SQL 2000 and i have used *= , =* many of places. So recently we are migrated to SQL 2008 and All reports I have to fixed for the 2008 standard.So I have couple of issue in compatibility like "The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80, using the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes."So It takes long time to re-query all things and fixing. Even we dont need to enable backword compatibility of 2008, we j't need to fixed all queries...SO my point is, DO we have any tool or something that fix all queries eaily. Thanks and Best Regards, |
|
|
|
|
|
T-SQL 2000 to 2008