Member Avatar for vkubushyn
vkubushyn 0 Newbie Poster

Hello everyone,

I searched extensively but was unable to find a solution to this problem. I'm attempting to generate the CREATE STATISTICS statement that was used to create an already existing statistics in an MSSQL db from its name or the table's name. I'm able to obtain the columns and the filter definition, but I cannot find anywhere that specifies the "FULLSCAN", "SAMPLE" and "STATS_STREAM" WITH options. I am querying the sys.stats and sys.stats_columns.

Please help me out with this! Thanks!

  • 1 Contributor
  • 0 Replies
  • 88 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.