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 |
|
jogin malathi
Posting Yak Master
117 Posts |
 Posted - 2007-02-21 : 01:29:07
|
| How Can I find the amount of taken by stored procedure to give outputIam using sql server 2005AS from .net screen -> view-> server ExplorerMalathi Rao |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-21 : 01:39:48
|
| Why don't you run it inside SSMS and see the time taken by it?Or else, you can manually time it by checking the difference between start time and end time.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-21 : 02:47:36
|
| or using SQL Profiler?Kristen |
|
|
|
|
|
|
time taken by procedure