Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Location
    Portland, Oregon
    Posts
    40

    Unanswered: Time spent returning recordset

    Is there a server variable which will tell me how long the server took in returning a particular recordset. I've looked through MSDN SQL 2000 articles and could'nt / did'nt see anything. Or perhaps there is another way? Thanks!

  2. #2
    Join Date
    May 2002
    Posts
    299
    there isn't a variable. but you can calc it.

    e.g.
    declare @t datetime
    set @t=getdate()

    --do you query

    select datediff(ms,@t,getdate())
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •