Forum Replies Created

Viewing 15 posts - 676 through 690 (of 9,720 total)

  • RE: Are the posted questions getting worse?

    Whee HAW!

    We survived! The big migration from system A to system B is completed and we ran a month end on the new system with few issues. Everything mostly...

    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.

    September 4, 2018 at 8:32 am

    #2004360

  • RE: Separating SSIS Datetime

    Jeff Moden - Tuesday, September 4, 2018 5:46 AM

    tmmutsetse - Tuesday, September 4, 2018 1:44 AM

    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.

    September 4, 2018 at 5:49 am

    #2004325

  • RE: Separating SSIS Datetime

    There are a couple of ways you can do this.

    1) Build the file import connection manager to treat date and time as two separate import columns. This is...

    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.

    September 4, 2018 at 5:35 am

    #2004323

  • RE: Dilemma when refreshing UAT from Prod

    And once you do what Grant instructed, if you still get the error, you need to look at the backup tables in MSDB to find out what the correct "earlier...

    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.

    September 4, 2018 at 5:24 am

    #2004322

  • RE: A call to ‘LogonUserW’ failed with error code : ‘1385’

    frobins - Friday, July 20, 2018 9:17 AM

    This still doesn't address why you got the LogonUserW failed error.  I recently experienced this...

    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.

    July 23, 2018 at 3:44 am

    #1998561

  • RE: Migrating data from one server to another

    KGNH - Thursday, June 28, 2018 1:00 AM

    NorthernSoul - Thursday, June 28, 2018 12:46 AM

    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.

    July 3, 2018 at 7:43 am

    #1996142

  • RE: Move files without moving subfolder files

    MG-148046 - Tuesday, July 3, 2018 6:19 AM

    I don't know if this still holds but the Powershell included with SSMS was a...

    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.

    July 3, 2018 at 7:16 am

    #1996132

  • RE: Move files without moving subfolder files

    So I thought this was solved, but the code I can run in the Powershell UI doesn't want to run in a SQL Job Step.

    Any thoughts on this...

    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.

    July 2, 2018 at 11:36 am

    #1996050

  • RE: Move files without moving subfolder files

    Thom A - Monday, July 2, 2018 7:30 AM

    Brandie Tarvin - Monday, July 2, 2018 7:12 AM

    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.

    July 2, 2018 at 7:36 am

    #1996008

  • RE: Move files without moving subfolder files

    For anyone else who reads this thread later, it helps to put a file existence check around the file move. Otherwise (as I just found out) the job step fails...

    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.

    July 2, 2018 at 7:31 am

    #1996006

  • RE: Move files without moving subfolder files

    Jeff Moden - Monday, July 2, 2018 6:49 AM

    I guess I don't understand why the equivalent of a DIR command on...

    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.

    July 2, 2018 at 7:12 am

    #1996001

  • RE: Move files without moving subfolder files

    Thom A - Monday, July 2, 2018 6:39 AM

    I'f I'm understanding correctly, Brandie, this should do what you want. By default Get-ChildItem...

    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.

    July 2, 2018 at 6:43 am

    #1995994

  • RE: Perfmon and PAL template issue

    Lynn Pettis - Friday, June 29, 2018 8:24 AM

    I found this: https://blogs.technet.microsoft.com/rmilne/2012/07/19/using-a-pal-template-to-easily-capture-performance-data/

    I have worked with PAL a few years ago but...

    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 29, 2018 at 9:05 am

    #1995828

  • RE: Are the posted questions getting worse?

    I have a perfmon / PAL template issue over at https://www.sqlservercentral.com/Forums/1971907/Perfmon-and-PAL-template-issue. If anyone could assist, I'd greatly appreciate it.

    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 29, 2018 at 4:16 am

    #1995764

  • RE: Object variables, ADO Recordsets, & decrypting column

    sgmunson - Friday, June 8, 2018 7:55 AM

    Brandie Tarvin - Wednesday, June 6, 2018 10:11 AM

    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 8, 2018 at 8:06 am

    #1993372

Viewing 15 posts - 676 through 690 (of 9,720 total)