Hi,

For SQL 2005 or after, you can get current job execution time from the view

msdb.dbo.sysjobactivity.

Hi there,

After you run the sp_spaceused stored procedure, it will show the correct rowcount.

I have done something that before.

Then I changed my practice.

for the SQL statement with where cluase,

I always do this,

update XXX set xxx = XXX Where -- must be one line with keyword

<where clause>

Although...