Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SP_Estimate_Compession_Savings Acquires a Schema Lock on Legacy Lob Data Types

Running sp_estimate_compression_savings against a table with legacy LOB (SQL 2000) data types acquires a schema modification lock that requires a instance restart. As detailed here:

https://www.sqlskills.com/blogs/jonathan/migrating-legacy-lob-data-types-to-current-ones-a-big-gotcha/

It's probably not worth fixing, but adding a check in the code and throwing a warning, might be a good idea.

2 votes
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)

We’ll send you updates on this idea

Joey Dantoni shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base