Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 9,715 total)

  • RE: SSIS package creation with txt file having multiple select statements

    aavi1011 (3/14/2016)


    App team provided select statements and want output of select statement as report in xls or csv format to thier email ID

    Is this a one off run or 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.

  • RE: Are the posted questions getting worse?

    In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not a working...

    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.

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (3/14/2016)


    Brandie Tarvin (3/14/2016)


    Eirikur Eiriksson (3/12/2016)


    Brandie Tarvin (3/11/2016)


    What a wonderful day in the upgrade-hood...

    Sigh.

    So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:

    Baggages?

    😎

    😛

    Still not sure if I like...

    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.

  • RE: Cannot drop the table 'TABLE' because at least part of the table resides on an offline filegroup.

    Leeland (3/14/2016)


    To get around this, I did have an actual full restore done on another server which wasn't being used at this time so I went through the process of...

    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.

  • RE: Potential presentation idea: The role of documentation in disaster recovery

    Also consider the need for roles during DR. Who is responsible for what tasks is critical to ensure everything gets up and running on time without duplicate effort.

    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.

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/14/2016)


    Shouldn't this have been your first stop before going online?

    someop (3/13/2016)


    Thanks for your response. Actually, I got solution from my manager. Thanks for your support

    Being fair, Lynn, my...

    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.

  • RE: Are the posted questions getting worse?

    Steven.Grzybowski (3/14/2016)


    Brandie Tarvin (3/14/2016)


    Eirikur Eiriksson (3/12/2016)


    Brandie Tarvin (3/11/2016)


    What a wonderful

    Still not sure if I like Data Tools or not. It seems very sensitive to every little click of the...

    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.

  • RE: Issue with LocalDB Instance after Windows 10 upgrade

    Thank you for posting your workaround and all the detail.

    I'm thinking you're correct that the error you receive has nothing to do with the real problem. On the other hand,...

    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.

  • RE: SSIS package creation with txt file having multiple select statements

    Why do you need a document with SELECT statements?

    Why can't you create a bunch of stored procedures and then use Data Flow Tasks with each stored procedure as your Source...

    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.

  • RE: SSIS package creation with txt file having multiple select statements

    Why do you need a text file for your SELECT statements? Do they change at all?

    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.

  • RE: Cannot drop the table 'TABLE' because at least part of the table resides on an offline filegroup.

    The obvious answer, which you indicated you might not be able to do because of size, would be to restore the entire database (not just the primary filegroup) down to...

    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.

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (3/12/2016)


    Brandie Tarvin (3/11/2016)


    What a wonderful day in the upgrade-hood...

    Sigh.

    So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:

    Baggages?

    😎

    😛

    Still not sure if I like Data Tools or not....

    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.

  • RE: Issue with LocalDB Instance after Windows 10 upgrade

    Windows 10 or Windows 2010?

    I don't know of any Windows 2010 release.

    What version of Windows was the user upgraded from? And was SQL 2012 32bit also or 64bit?

    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.

  • RE: Potential presentation idea: The role of documentation in disaster recovery

    As an added note, I worked for Iron Mountain Records Management when 9/11 happened. I remember well the tales of the New York office getting people up and running right...

    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.

  • RE: Unable to start SQLAgent - MSDB is Read-Only

    Vyper426 (3/11/2016)


    No. about 800GB available on that drive.

    Just before this, MSDB had been corrupted. We took the backup from the backup system and replaced it. The backup system does not...

    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.

Viewing 15 posts - 1,966 through 1,980 (of 9,715 total)