TSEQUAL and JOIN syntax as *= or =* not supported in SQL Server 2008

I have faced an issue during SQL Server Migration. Here sharing with you.

As I need to move some databases from SQL Server 2000 to SQL Server 2008 then I faced a problem because TSEQUAL and JOIN syntax such as *= or =* not supported in SQL Server 2008.

Some of scripts are using the function and syntax as

Example:

• TSEQUAL (TxnStatus, @ciTxnSts)
• JOIN syntax which has *= and =* to specify the OUTER JOIN.

Solution:

• TxnStatus = @ciTxnSts instead of  TSEQUAL (TxnStatus, @ciTxnSts)
• Outer Join = instead of *= and =*

If anybody has any other idea please share as comment.