Wednesday, September 26, 2012

SSMA error message S2SS0002

The following SQL statement cannot be converted

CREATE TABLE tempdb.guest.temptable (
                                 user_id int NOT NULL,
                                 req_id int NOT NULL
                                                                 )
                                 LOCK  DATAROWS
LOCK  DATAROWS keyword is not available in sql server.
To achieve the same in sql server, we should give nolock for the select statments involving the above table  or else we should set the isolation level as 'Read uncommitted '.

Please click here to know about sybase to sql server migration issues

No comments:

Post a Comment