Have you ever tried to create statistics using SSMS (SQL Server Management Studio) and found that the option to script the statistics is always disabled? You’re not alone. Many users have encountered this issue and wondered if there is a way to copy statistics from one server to another. In this blog post, we will explore the reasons behind this behavior and provide a solution.

The first thing to note is that the option to script statistics is disabled across all databases, regardless of their status (read-only or not). This is a limitation of SSMS and not specific to read-only databases. So, how can we create or copy statistics from a table or view?

The solution lies in using a different method in SSMS. Instead of trying to script the statistics directly, we need to right-click on the database and select the “Script Table/View with Statistics” option. This will enable the scripting of the table along with its statistics details.

Once you have selected this option, you will be able to generate a script that includes the statistics for the table or view. This script can then be used to create or copy the statistics to another server.

If you’re looking for a step-by-step guide on how to copy statistics from one server to another, I have written a detailed blog post on this topic. You can refer to it for a comprehensive solution. The blog post is titled “SQL SERVER – Copy Statistics from One Server to Another Server.”

It’s important to note that scripting the table or view with statistics is the only way to enable the creation or copying of statistics using SSMS. If you come across any other methods or solutions, I would be glad to hear about them and share them with the community.

So, the next time you encounter the disabled option to script statistics in SSMS, remember to use the “Script Table/View with Statistics” option to create or copy statistics. It’s a simple workaround that can save you time and frustration.

Thank you for reading and happy scripting!