Forum Replies Created

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

  • RE: SQL Server Logon Trigger Problems

    maleitzel 96965 (3/21/2013)


    I thought maybe somebody had a magic bullet for this!

    The magic bullet for me was putting the SET options within the trigger to bypass any inconsistencies in 3rd...

  • RE: Better Backups

    neprosto (1/23/2012)


    wrong answer A & C !

    When we enable compression we increase the cpu load and decrease the io load as we need less space for saving beckup. So we...

  • RE: "Buffer provided to read column value is too small" Error on SQL 2008 R2

    This is a known issue and we had a PSS case investigating the same. If possible, you could use a workaround by creating a Linked Server connection on SQL 2000...

  • RE: sql server agents

    SQL Agent is not supported on SQL Express edition.

    Depending on what you wish to do there is an alternative of using sqlcmd with windows scheduled jobs

    Check out these link for...

  • RE: errors in jobs with sql sevierity

    Can you post more information on what the job does?

  • RE: On call support experience

    There is plenty of information out there with regards to troubleshooting scenarios and each person's on-call experience will differ from another based on the environment, SLA's, business stake holder relationship,...

  • RE: TSQL get simplified range as a result

    Hi Koen

    This could be the solution?

    SELECT

    SUM(DC.DISCOUNT_ID),

    MIN(AGE.MIN_AGE) MIN_AGE,

    MAX(AGE.MAX_AGE) MAX_AGE,

    AGE.MIN_FULLPAYERS,

    BP.[FROM],

    BP.TILL,

    DC.DISCOUNT

    FROM @discount DC

    INNER JOIN...

  • RE: Checkpoint Blocking Log Backups

    Hi Bhuvnesh

    Thanks for posting the link, exactly the behaviour that could be affecting in this case. Since the manual checkpoint takes precedence over a system one, if issuing a manual...

  • RE: Checkpoint Blocking Log Backups

    Hi Rajan

    A manual Checkpoint takes precedence over a queued system checkpoint. Can you run a manual checkpoint in the context of the affected database and see if you continue to...

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