InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 15:01:35 GMT20http://www.sqlservercentral.com/Forums/Topic989188-5-1.aspxThanks Jack Corbett.Yes, Now, I want to know how I can find the duration of that query ? i.e start time and end time.Is there any script or query or Stored procedure to find this.Regards,Ravichandra.Mon, 20 Sep 2010 23:51:04 GMTravisamigohttp://www.sqlservercentral.com/Forums/Topic989188-5-1.aspxAre you saying that you created an index in SQL Server and it took a full day to finish?Mon, 20 Sep 2010 17:09:10 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic989188-5-1.aspxDear All,I have created index on table in user database through SSMS wizard 2days back,on that time it was executing and it was finished in next day.Now my question is, I want to know the total duration i.e, how much time that query was taken to be finished?From this, I want to estimate the time and have to apply the same on production environment.Thanks and Regards,Ravichandra.Mon, 20 Sep 2010 03:21:17 GMTravisamigo