Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Monitoring Long Running Agent Jobs

    Hi,

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

    msdb.dbo.sysjobactivity.

  • RE: Working With System Tables

    Hi there,

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

  • RE: The DBA Whoops

    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...

Viewing 3 posts - 1 through 3 (of 3 total)