Can't delete any assignment - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Administration

Can't delete any assignment

Author

Topic

ibraheemmagdy
Starting Member

1 Post

Posted - 2014-06-17 : 08:04:19

when i try to delete any assigned item, this message appeared with event
code

DSETQ-3615-F

Description:
Database Server Error: 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 or lower, using stored procedure sp_dbcmptlevel. 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.

imagdy

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-06-17 : 10:17:56

quote:
Originally posted by ibraheemmagdy

when i try to delete any assigned item, this message appeared with event
code

DSETQ-3615-F

Description:
Database Server Error: 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 or lower, using stored procedure sp_dbcmptlevel. 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.

imagdy

The error message describes the issue and what you need to do about it. In old versions of SQL, you could implement LEFT and RIGHT joins using a *= or =* syntax. That was discontinued in favor of ANSI joins. SQL Server supported it for a while as long as you kept the "compatibility level" at 80 or less.

Is this a vendor software that you are using? If so, contact the vendor ask them to fix the problem. They may need to send you revised code and or database scripts.

If it is your own code, look into the SQL statements that implement the delete. If you need help translating them to ANSI joins, post some samples here.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources