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 |
|
sathiesh2005
Yak Posting Veteran
85 Posts |
 Posted - 2009-12-04 : 01:01:26
|
| Hi Everyone,I am using SQL server2000 as backend and ASP/ASP.net as frontend.I need to check whethere my SQL query in and ASP/.net page using the index or not throuth the frontend itself.Is it possible??Waiting for your kind reply.Thanks in advance.Regards,Sathieshkumar. RSathieshkumar. R |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2009-12-04 : 02:55:33
|
| Why do you want to do it in front end only? |
 |
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2009-12-04 : 03:40:00
|
Since the index tuning wizard/profiler runs with administrator rights, admin rights cannot be given to all the users of sql server. so i need it to do throught the frontend so that i can connect this page with administrator login and others can access this page.Thanks for your reply.quote:
Originally posted by cvraghu
Why do you want to do it in front end only?
Regards,Sathieshkumar. R |
|
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
|
|
|
|
|
Is it possible to find use of index in a query