Forum Replies Created

Viewing 15 posts - 5,176 through 5,190 (of 19,560 total)

  • RE: database email

    Looks correct to me.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 16, 2013 at 12:04 pm

    #1577988

  • RE: database email

    That could be a rather large email.

    But yes you can do that.

    start with a little reading on the procedure that sends emails.

    http://msdn.microsoft.com/en-us/library/ms190307.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 16, 2013 at 11:07 am

    #1577967

  • RE: database email

    We would need more details. The info is pretty limited in order to provide a viable solution.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 16, 2013 at 10:56 am

    #1577965

  • RE: Need to convert Varchar to Money with symbols

    DECLARE @amt VARCHAR(20) = '5000'

    SELECT REPLACE('$' + CONVERT(VARCHAR(20),(CAST(@amt AS MONEY))),'$-','-$')

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 16, 2013 at 10:37 am

    #1577957

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (1/16/2013)

    SQLRNNR (1/16/2013)

    WayneS (1/16/2013)

    Anyone in the Charlotte, NC area with an electric leaf blower (preferably battery powered!) that I can borrow for next year's PASS Summit? :w00t::crazy:

    I think you...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 16, 2013 at 10:07 am

    #1577942

  • RE: TRY...CATCH

    Thanks for the question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 16, 2013 at 9:57 am

    #1577932

  • RE: Are the posted questions getting worse?

    WayneS (1/16/2013)

    Anyone in the Charlotte, NC area with an electric leaf blower (preferably battery powered!) that I can borrow for next year's PASS Summit? :w00t::crazy:

    I think you can rent one...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 16, 2013 at 9:55 am

    #1577926

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/15/2013)

    dwain.c (1/15/2013)

    Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:

    Woooohoooo!!! My 2000th post! Time to celebrate!

    Good grief! Seems...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 15, 2013 at 11:08 pm

    #1577643

  • RE: Are the posted questions getting worse?

    dwain.c (1/15/2013)

    Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:

    Woooohoooo!!! My 2000th post! Time to celebrate!

    Good grief! Seems like only...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 15, 2013 at 11:07 pm

    #1577642

  • RE: Index rebuild/reorg script Validation

    dedicatedtosql (1/15/2013)

    Thanx for the advice on the Ola Hallengren script. I will suerly look into it. The only prob is I would like to go with those scripts that I...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 15, 2013 at 12:09 pm

    #1577466

  • RE: Getting field value from notepad

    What are you trying to accomplish?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 15, 2013 at 11:40 am

    #1577456

  • RE: Index rebuild/reorg script Validation

    While there is Ola's script, there is also a widely accepted script by Michelle Ufford

    http://sqlfool.com/2011/06/index-defrag-script-v4-1/

    This one is also widely accepted and works.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 15, 2013 at 11:38 am

    #1577453

  • RE: Today's Random Word!

    Revenant (1/15/2013)

    Cliff Jones (1/15/2013)

    SQLRNNR (1/15/2013)

    crookj (1/15/2013)

    Daniel Bowlin (1/15/2013)

    attitude

    Adjustment.....:exclamation:

    purple

    rain

    TAFKAP

    Identity Seed problems

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 15, 2013 at 9:58 am

    #1577412

  • RE: Today's Random Word!

    crookj (1/15/2013)

    Daniel Bowlin (1/15/2013)

    attitude

    Adjustment.....:exclamation:

    purple

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 15, 2013 at 9:08 am

    #1577386

  • RE: Report Parameters Selected Shown in Report and/or Footer

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    January 15, 2013 at 8:58 am

    #1577380

Viewing 15 posts - 5,176 through 5,190 (of 19,560 total)