Follow

Error: "Computed column 'BK Hash Key' in table 'table_name' cannot be persisted because the column is non-deterministic"

Symptoms

You're running SQL Server 2005 < SP1 and receive an error like the one below at deployment time.

Msg 4936, Level 16, State 1, Line 2 Computed column 'BK Hash Key' in table 'table_name' cannot be persisted because the column is non-deterministic.

Cause

The most likely cause is a bug in the RTM version of SQL Server 2005, where hashbytes was marked as non-deterministic​.

Resolution

Upgrade your SQL Server to a more recent service pack.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.