Forum Replies Created

Viewing 15 posts - 61 through 75 (of 366 total)

  • RE: Database mail configuration

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

    There where...

  • RE: Database mail configuration

    Lowell (6/1/2012)


    Manie the key is the specific error messages you see in msdb.sysmail_faileditems.

    take a look at the data from this SELECT statement:

    are all the err.[description], basically the same? what is...

  • RE: insert multiple rows into variable

    Boltz42 (5/17/2012)


    I took one look at this article and thought "What's so special about this?" It's hardly revolutionary!

    I agree. I do not see the purpose for this. You would anyway...

  • RE: Create Login Script

    K. Brian Kelley (5/10/2008)


    The problem is that CREATE LOGIN and ALTER LOGIN won't take the variable. The way around this is to use Dynamic SQL. For instance:

    CREATE PROCEDURE dbo.Create_Login

    @username sysname

    AS

    BEGIN

    SET...

  • RE: Create Login Script

    Hi guys,

    Sorry for never giving feedback here but work has been hectic taking all my free time but no, sorry Brian I could not get your script going and was...

  • RE: Foreign key constraints

    Thanks guys for all the replies. I have actually decided that I am after all not to do it and rather check the tables as I go and where necessary...

  • RE: Foreign key constraints

    This project that I am doing has been coming with me ever since I inherited this database. I have been walking into walls in many ways because of a lack...

  • RE: The Data Resolutions

    Hi Steve,

    I wish you and your family as well as everybody on SSC a splendid and blessed 2012. May we all prosper in the New Year. My goal (rather than...

  • RE: Never offend a captive audience

    I honestly do not understand why people, in any sphere of life, has to spice their words with swearing and bad language. It is bad taste.

  • RE: The Good Job

    Steve, you are so right. Be thankful for what you have and if you are unhappy find something else. However, in the current economic climate I would say hold on...

  • RE: Tax Day

    Do I do better now than last year? Well, let me put it this way. I still have a job and I am thankful for that.

  • RE: Tell Me What I Need To Know

    Hi Andy, very nice and accurate article indeed. You see I am in the unique situation where my boss wants me to work from home on days I do not...

  • RE: The Stairway Series

    At this point in time I am battling to read at least 3 articles a week so I can at least grow a bit but hey, I also don't complain....

  • RE: Most Work is Mundane

    I won't say I do not have any mundane or boring parts in my job but fortunately that I in the minimum and yes, I have also learnt to automate...

  • RE: Preventing usage of "SELECT *..."

    cphite (2/14/2011)


    Interesting solution, but honestly I think a far better solution is to train your developers to avoid doing things like SELECT * in production code, along with having a...

Viewing 15 posts - 61 through 75 (of 366 total)