<div>
Hello Sandeepiii,<br />
<br />
Another way would be to log the steps your sproc is taking in a &quot;log table&quot;. &nbsp;For example, you could insert<br />
a row at the start of the procedure and at the end of the procedure, each time using GETDATE() to populate<br />
a time stamp. &nbsp;(You could also log intermediate steps if you are so inclined.)<br />
<br />
Regards,<br />
<br />
Patrick
</div>


Hello Sandeepiii,

Another way would be to log the steps your sproc is taking in a "log table".  For example, you could insert
a row at the start of the procedure and at the end of the procedure, each time using GETDATE() to populate
a time stamp.  (You could also log intermediate steps if you are so inclined.)

Regards,

Patrick

<div>
<div class="content wysiwyg-content">
Can i know particular stored procedure is taking time to execute .<br />
Basically want to know how much time it takes to complete.<br />
Iam using sql server 2005 std edition , 
</div>
</div>


Can i know particular stored procedure is taking time to execute .
Basically want to know how much time it takes to complete.
Iam using sql server 2005 std edition , 

time duration stored procedure is taking

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.