I'm trying to encrypt a column and am getting the following error: Set-SqlColumnEncryption : Lock request time out period exceeded. Are there parameters to specify the lock timeout? What could be locking it? The table has about 10k records. It works fine with empty tables or tables with hundreds of records.

  • Try turning off any applications or users that may be doing frequent queries on that table. The latter of the two may be easier said than done :) Jun 5 '18 at 20:57

Apparently, you can't have certain options turned on for the table, like "large value types out of row". Here's what I did:

exec sys.sp_tableoption @TableNamePattern = 'dbo.SomeTableName' ,@OptionName = 'large value types out of row' ,@OptionValue = 'off';

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.