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
Check!
(thinking…)
Reset
or sign in with
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base