Forum Replies Created

Viewing 15 posts - 46 through 60 (of 367 total)

  • RE: The Vacation Struggle

    In South Africa December is summer and therefore lots of companies close then. We close for three weeks and sometimes two. Three weeks is my holiday leave for the year...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Limiting the number of databases on an instance.

    Abu Dina (6/19/2013)


    CREATE TRIGGER [DDLTriggerLimitNumberOfDBs]

    ON ALL SERVER

    FOR CREATE_DATABASE

    AS

    SET NOCOUNT ON

    DECLARE @MSG VARCHAR(500)

    ...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: The Importance of Reading Comments

    Perry, I hope we are at peace now. I have a feeling I can still learn a lot from you.:-)

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: The Importance of Reading Comments

    Perry,

    Thank you I actually did go and read your article and actually have learnt something new. I also saw another article[/url] that clearly explained the disadvantages of detach/attach.

    I must honestly...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: The Importance of Reading Comments

    Perry Whittle (6/11/2013)


    Manie Verster (6/10/2013)


    You have chosen to link a rather ancient article that covers SQL Server 7.0, 2000, 2005 which is no longer relevant. Under SQL Server 2000 you...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: The Importance of Reading Comments

    Your story also emphasizes the importance of having a test environment. Having one has saved me many times.

    I think it is very important to TEST all scripts gotten from...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: The Importance of Reading Comments

    Jeff Moden (6/10/2013)


    Nice article, Mannie. Yes... I absolutely agree. Reading the comments is important. That's why most of the scripts I post on the forums say "Details...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: The Importance of Reading Comments

    I remember that thing. The first two instructions indicated that you were to put your name and date on the test (different spots, depending on the test) and that was...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: The Importance of Reading Comments

    You have chosen to link a rather ancient article that covers SQL Server 7.0, 2000, 2005 which is no longer relevant. Under SQL Server 2000 you had to detach a...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: The Importance of Reading Comments

    The point of this article is not whether it is the best way of doing it but to READ the whole article and/or comments BEFORE you start because you could...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: SQL Server Database Mail

    sqldbalearner (5/4/2013)


    I had faced some issues in DBmail configuring , try checking the SSL this helped me once(Check button).

    Actually my SSL is checked and I also found out that gmail...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Import without SSIS

    Unfortunately, I think, you will have to import each file manually using the wizard. Sql Server express does not leave you with a lot of options. Somebody correct me if...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Track changes to database objects

    Thanks for the script. I just need you to please post me the script for sp_getDDL then I can fully test this solution and see if it will work for...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Log shipping throw errors

    Yes! I know but how and to what? I don't have a cooking clue. Can you help maybe, Perry?

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

  • RE: Database mail configuration

    anthony.green (6/6/2012)


    Manie Verster (6/1/2012)


    anthony.green (6/1/2012)


    I might be wrong, but I thought that option was for SQL Mail and not DB Mail so therefore shouldn't be in 2012 as SQL Mail...

    :-PManie Verster
    Developer
    Johannesburg
    South Africa

    I can do all things through Christ who strengthens me. - Holy Bible
    I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

Viewing 15 posts - 46 through 60 (of 367 total)