Forum Replies Created

Viewing 15 posts - 5,806 through 5,820 (of 9,722 total)

  • RE: Datetime Conversion Issue in SSIS - Need Help

    Can you please tell us how you have your Source set up to use the parameters?

    Also, tell us what the parameter sources are. (I just want to verify something).

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 9:20 am

    #1339070

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/15/2011)

    Brandie Tarvin (6/15/2011)

    I think y'all are just adding posts to get extra points!

    :w00t:

    Whut? No way. Not possible.

    Yes way.

    For example: If you haven't figured it out, Steve...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 9:15 am

    #1339065

  • RE: Are the posted questions getting worse?

    Oh, wait. I forgot to grab some points for me too.

    Congrats, Grant. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 8:55 am

    #1339041

  • RE: Are the posted questions getting worse?

    I think y'all are just adding posts to get extra points!

    :w00t:

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 8:54 am

    #1339040

  • RE: Today's Random Word!

    High

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 8:49 am

    #1339035

  • RE: Datetime Conversion Issue in SSIS - Need Help

    robin 86662 (6/14/2011)

    Can someone help me using T-SQL to convert this value: '2011-06-11 16:34:29.123' into this format '6/11/2011 4:34:29.123 PM' (this is the legacy format). Then maybe I can...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 8:28 am

    #1339011

  • RE: Today's Random Word!

    Smoke

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 8:13 am

    #1339005

  • RE: what is role of SSAS DEVELOPER in the Projects

    FYI: We don't know what you mean by Retails Domain project. That reference is lost on us. All we can do is tell you what an SSAS developer usually does...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:57 am

    #1338993

  • RE: FTP Task in Script Task

    Ditto to opc.three's comment. But just to clarify, you can do these two pieces in the same SSIS package (I'm sure that's what he meant).

    SSIS isn't meant to do...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:55 am

    #1338988

  • RE: SSIS ODBC Help Please

    Can't access anything?

    Please be more specific in the steps you use to create your Data flow. Tell us what items you are choosing and how you're connecting them together.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:54 am

    #1338987

  • RE: Restoring a dropped table

    msenel (6/15/2011)

    in this case SQL server works just like Oracle, restore Full backup and then TRN log until the point where you dropped the table ( using stopat=timestamp)

    Just to point...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:45 am

    #1338981

  • RE: Restoring a dropped table

    hammad772001 (6/15/2011)

    Hi John

    When I took the Database backup I also took the backup of Transaction Log. In case the MDF files are missing, how can we restore using a full...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:43 am

    #1338977

  • RE: Sql "incremental" Backups

    When referring to Windows Incremental backups (or Outlook Email system backups), the backup type backs up data. Since the Transaction Log backs up the SQL Server log, not the data...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:38 am

    #1338975

  • RE: Backup Duration

    gmamata7 (6/13/2011)

    In view history, it says 01:43:53 (1 hr 43 mins) and in the backup log, it says 3050.662 seconds (53 mins).

    Could you please clarify me which one is correct?

    Maybe...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:35 am

    #1338970

  • RE: How much disk free space to keep on drives and why?

    I prefer to know that I'm going to have at least 2 years worth of growth out of my free space. So I add more than enough to account for...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:32 am

    #1338966

Viewing 15 posts - 5,806 through 5,820 (of 9,722 total)