Forum Replies Created

Viewing 15 posts - 31 through 45 (of 99 total)

  • RE: Converting bigint value to time

    Like this how can i convert 131401986 to 02/09/2005

  • RE: Decimal to datetime

    131402252 decimal is changing to 02/09/2005 8:37:16

  • RE: Decimal to datetime

    // This formula uses the two prompts 'From_Date' and 'To_Date' filled in by the user

    // to control the date range for which the data is displayed in the report.

    //...

  • RE: Decimal to datetime

    i tried that but my decimal date is in the format 131402252

  • RE: dropping multiple jobs

    Brandie Tarvin (3/29/2010)


    One potential problem I see right off the bat. You're dropping the job off it's modified date instead of it's last run date, which is what you originally...

  • RE: dropping multiple jobs

    Brandie Tarvin (3/29/2010)


    One potential problem I see right off the bat. You're dropping the job off it's modified date instead of it's last run date, which is what you originally...

  • RE: dropping multiple jobs

    shanila_minnu (3/29/2010)


    shanila_minnu (3/29/2010)


    Brandie Tarvin (3/29/2010)


    No, I don't have a query. I've never needed to write one.

    It's not that hard, though. Look up the code in Books Online. It's the best...

  • RE: dropping multiple jobs

    shanila_minnu (3/29/2010)


    Brandie Tarvin (3/29/2010)


    No, I don't have a query. I've never needed to write one.

    It's not that hard, though. Look up the code in Books Online. It's the best way...

  • RE: dropping multiple jobs

    Brandie Tarvin (3/29/2010)


    No, I don't have a query. I've never needed to write one.

    It's not that hard, though. Look up the code in Books Online. It's the best way for...

  • RE: dropping multiple jobs

    Brandie Tarvin (3/29/2010)


    Use a WHILE loop or a CURSOR on the sp_delete_job command.

    The table sysjobhistory contains the columns run_date and run_time. You can use those columns to determine the last...

  • RE: memory hitting 95% in one server

    Welsh Corgi (2/19/2010)


    When did this problem start happening?

    I was not clear if this is happening 24/7 or not?

    Have you gone into task Manager checked show all process and...

  • RE: memory hitting 95% in one server

    Welsh Corgi (2/19/2010)


    When did this problem start happening?

    I was not clear if this is happening 24/7 or not?

    Have you gone into task Manager checked show all process and...

  • RE: memory hitting 95% in one server

    i will check & let you know

  • RE: SQL 2000 clustering

    In my environment there is 2 node clustering(A & B).For the past two months active node was 'A' ,At that time in aparticular time say ,3.00 PM memory usage...

  • RE: SQL 2000 clustering

    Is there any way to check when did the last failover happens

Viewing 15 posts - 31 through 45 (of 99 total)