Forum Replies Created

Viewing 15 posts - 91 through 105 (of 120 total)

  • RE: Setting Transaction Log File Properties

    Thanks for the heads up about that site. i wasn't able to find the specific article you suggested as that site's search function isn't very good and the article titles...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Help! Connection to server seems to be dead!

    While researching an issue with my transaction logs, I cam across this on msdn:

    from http://support.microsoft.com/?id=317375

    In addition to this error message, SQL Server may mark databases suspect because of a lack...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Setting Transaction Log File Properties

    lol.. I think you are right about the bad code. No one at my shop is an expert in dbs and unfortunately when the issue of performance hampering behaviors comes...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Setting Transaction Log File Properties

    You're right ...i checked and the transaction logs are backed up every hour. Thanks!

    I read the article and it was very good. It filled in some details that other, mostly...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: does anyone else encounter forum down problem?

    I'm using IE 7 too but get a 400 error. Works good in Firefox. I'm beihind a firewall so maybe that has something to do with it.

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Help! Connection to server seems to be dead!

    lol..Actually, if you reread my initial post I was only asking questions about his situation and suggesting he try telnetting intot he machine if it was unreachable... not terrible advice...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Help! Connection to server seems to be dead!

    Just running out of space shouldn't make a DB suspect. Suspect means that either a transaction rollback failed or the service was restarted, restart recovery started and then failed.

    Thanks Gila...I...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: ISsue while connecting the SQL Server db from ASP page -

    You probably mistyped your dbname or password. Have another look at that connection string as that is usually the cause of the problem.

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Connection Timeouts

    What about Enterprise Manager -->Tools --> Options --Advanced Tab -> Login Timeout?

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Help! Connection to server seems to be dead!

    Any idea why it was flagged as suspect to begin with?

    mine ran and completed in 5 seconds. If your server is in heavy use when you ran it perhaps...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Best practices: Monitoring health of SQL database?

    I'm an Accidental DBA as well. Just in the past month I have been putting together a small kit of T-Sql, PerfMon routines and a Log analyzer.

    Google on "Brad McGehee"...

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: does anyone else encounter forum down problem?

    I tried to add a reply but kept getting a 400 http error..bad request.

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: could someone please help to improve the performance of this store proc,it takes 2hrs 30mins to execute

    "While 1 = 1" ?? I'm surprised it ever ends! lol

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Cleaning up a Database

    ha ha ha..Thanks Ten Centuries! I appreciate the links and the humor. It helps keep this in perspective 🙂

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • RE: Cleaning up a Database

    The dataimport worked fine. At least it got it into sql server for me to work on it. Only one table failed to import but I can work around that....

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

Viewing 15 posts - 91 through 105 (of 120 total)