09-09-02, 10:04 #1Registered User
- Join Date
- Jul 2002
I want to be able to read the statisitcis properties.
I create statistics like this:
create statistics stat on [test] (name) WITH FULLSCAN, NORECOMPUTE
executing "exec sp_helpstats 'test' " only give me the statistics name and columns.
How can I see if a statistics object has the FULLSCAN and/or NORECOMPUTE property ?