Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avdhoot_saple
Starting Member
1 Post |
 Posted - 2007-04-19 : 01:25:44
|
| I am able to collect and display statistics using sp_createstats and DBCC SHOW_STATISTICS, but I need to use those values for some calculations. Is there any way by which I can query those values to extract them ? or is there any table where those values are stored ? |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-04-19 : 13:07:42
|
quote:
Originally posted by avdhoot_saple
I am able to collect and display statistics using sp_createstats and DBCC SHOW_STATISTICS, but I need to use those values for some calculations. Is there any way by which I can query those values to extract them ? or is there any table where those values are stored ?
have u tried to call these SPs from ur business logic? which platform u r using? u can execute them thru COMMAND object.may be i m wrong, coz i hvn't tried it.Mahesh |
 |
|
|
|
|
|
Using statistics