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 |
|
jayadev1
Starting Member
2 Posts |
 Posted - 2004-07-07 : 06:42:20
|
| hai all, i am working on a java application which has to store the statistics of a given query (like nodeid, totalsubtreecost etc) in a user table. is there a way for it? statistics that can be viewed by (SET STATISTICS PROFILE ON ......<query> .......SET STATISTICS PROFILE OFF) actually i have tried options like storing the statistics to a text file and then storing back to user table, but that needs to go to sql query analyzer and set the option to store to a file. also, i cannot use isql or DTS packages, since i am approaching from a java application.any suggestions? thanks in advancejayadev |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-07-07 : 07:06:44
|
| duplicate of....http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37165 |
 |
|
|
|
|
|
storing statistics in a table?