jeudi 24 décembre 2015

How do we workout with SQL Hints in tSQLt unit testing?

I have been trying to create unit tests for one of the stored procedures in my database using tSQLt and facing one issue,

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.[16,1]{spPlaceNewOrder,56} (There was also a ROLLBACK ERROR --> The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction.{Private_RunTest,161})

Can someone please help me on this?

Aucun commentaire:

Enregistrer un commentaire