Forum Replies Created

Viewing 15 posts - 7,336 through 7,350 (of 19,564 total)

  • RE: The Data Resolutions

    I have a list full of things I have been planning on doing such as articles, blogs, basement and BI certification. I plan on knocking some of those things...

    December 30, 2011 at 10:46 am

    #1427071

  • RE: Are the posted questions getting worse?

    GilaMonster (12/30/2011)

    Stefan Krzywicki (12/30/2011)

    SQLRNNR (12/30/2011)

    Stefan Krzywicki (12/30/2011)

    Cool. I used to play RPGs, but just can't get interested in them any more.

    This is what you guys are talking about, right?

    Sometimes!...

    December 30, 2011 at 10:20 am

    #1427064

  • RE: Query Result in Mail

    Use the file attachment option

    , [ @attach_query_result_as_file = ] attach_query_result_as_file ]

    @attach_query_result_as_file = yourfile.xls or csv

    December 30, 2011 at 10:13 am

    #1427062

  • RE: New Year's Eve Query

    L' Eomot Inversé (12/30/2011)

    jeff.mason (12/30/2011)

    If someone says that the registration date is more useful in their country and that this is an American-centric difficult question I will scream.

    Now, let me...

    December 30, 2011 at 10:03 am

    #1427057

  • RE: Setting up Database mail using gmail account

    tcnolan (4/6/2009)

    Mark Sumner (4/6/2009)

    tnolan (4/6/2009)

    Try this...

    Use smtp.gmail.com for the server

    smtp.gmail.com is the outbound from gmail smtp server. It will refuse your relay request.

    If that doesn't work, you could try installing...

    December 30, 2011 at 10:01 am

    #1427055

  • RE: Query Result in Mail

    Using your proc and the email query it works fine for me under the following circumstances.

    The database the query is executing from is msdb or I use the three part...

    December 30, 2011 at 9:58 am

    #1427051

  • RE: Today's Random Word!

    L' Eomot Inversé (12/30/2011)

    A newspaper is a device for making the ignorant more ignorant and the crazy crazier.

    And for killing flies.

    December 30, 2011 at 9:27 am

    #1427036

  • RE: Query Result in Mail

    Are you able to send a test email through dbmail?

    December 30, 2011 at 9:10 am

    #1427025

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/30/2011)

    Cool. I used to play RPGs, but just can't get interested in them any more.

    This is what you guys are talking about, right?

    December 30, 2011 at 9:08 am

    #1427024

  • RE: Use an AD group for SQL Authentication

    SQL Server permits the use of groups no problem. The issue actually seems to be that your syspro app requires SQL Auth.

    Here's an article on the authentication methods of...

    December 30, 2011 at 8:50 am

    #1427012

  • RE: Get the delta records between 2 tables with same structure

    For things like this I usually rely on RedGate Data Compare.

    December 30, 2011 at 8:45 am

    #1427005

  • RE: Are the posted questions getting worse?

    Roy Ernest (12/30/2011)

    Before I forget, Let me wish you all a very happy and prosperous New Year, 2012.

    What if we decide to visit your casino - do you still wish...

    December 30, 2011 at 8:41 am

    #1427003

  • RE: Query Result in Mail

    Does JobSummaryUtil exist in msdb?

    December 30, 2011 at 8:37 am

    #1426996

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/30/2011)

    GilaMonster (12/30/2011)

    Ninja's_RGR'us (12/30/2011)

    Good game Steve???

    Err, yeah. Sorry. Too much online gaming lately.

    On the plus side, an online play-by-post roleplaying game is better than nothing and can be a...

    December 30, 2011 at 8:28 am

    #1426989

  • RE: Query Result in Mail

    K - how about the send_db_mail query that you are using?

    December 30, 2011 at 8:27 am

    #1426987

Viewing 15 posts - 7,336 through 7,350 (of 19,564 total)