Forum Replies Created

Viewing 15 posts - 1,906 through 1,920 (of 9,720 total)

  • RE: Are the posted questions getting worse?

    At risk of flung porkchops and a revocation of my invitation to the Tent in the Desert...

    Many years ago, I attended a webinar hosted by our own Gail Shaw (may...

    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.

    March 31, 2016 at 6:06 am

    #1868805

  • RE: Are the posted questions getting worse?

    Sean Lange (3/30/2016)

    Brandie Tarvin (3/30/2016)

    Sean Lange (3/29/2016)

    We have a stringent list of requirements:

    •Have a pulse.

    •Be reasonably competent as a developer.

    So basically you're discriminating against vampires and zombies.

    Good to know. I'll...

    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.

    March 30, 2016 at 7:45 am

    #1868595

  • RE: Are the posted questions getting worse?

    Sean Lange (3/29/2016)

    We have a stringent list of requirements:

    •Have a pulse.

    •Be reasonably competent as a developer.

    So basically you're discriminating against vampires and zombies.

    Good to know. I'll warn my cousin 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.

    March 30, 2016 at 5:31 am

    #1868538

  • RE: Are the posted questions getting worse?

    jasona.work (3/29/2016)

    Of course, if he sent me out looking for brake light fluid, I'd run down to the little shop and grab a Mountain Dew...

    :hehe:

    And now we know why you...

    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.

    March 29, 2016 at 11:33 am

    #1868347

  • RE: Question on SQL Cluster plus Failover Data Center plus SQL Agent Jobs

    happycat59 (3/28/2016)

    You said that the new environment is a SQL failover cluster. If this is correct, there is no need to worry about SQL Agent Jobs.

    That's not true....

    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.

    March 29, 2016 at 3:48 am

    #1868165

  • RE: Adding SSRS Browser permission

    TheAccidentalDBA (3/28/2016)

    Are you accessing the report manager internally on the server that has SSRS installed or externally?. If the there is firewall issues connecting externally, you can RDP to 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.

    March 29, 2016 at 3:45 am

    #1868164

  • RE: SSIS import of multiple, variably named CSV files

    TheAccidentalDBA (3/28/2016)

    You create table and stored procedure to do this. First populate the table with the name of all the files in the folder. Then call the stored procedure 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.

    March 28, 2016 at 9:59 am

    #1868019

  • RE: Login can't be deleted because it granted permissions

    jasona.work (3/28/2016)

    Brandie Tarvin (3/28/2016)

    <headdesk>

    IMPERSONATE.

    That's the stupid hangup. IMPERSONATE.

    GAH.

    Could be worse...

    You could've not found anything...

    😀

    Rather annoying though, how difficult it can be to track down things like this, in the UI.

    Finding...

    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.

    March 28, 2016 at 9:21 am

    #1867999

  • RE: Login can't be deleted because it granted permissions

    <headdesk>

    IMPERSONATE.

    That's the stupid hangup. IMPERSONATE.

    GAH.

    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.

    March 28, 2016 at 8:46 am

    #1867989

  • RE: Login can't be deleted because it granted permissions

    jasona.work (3/28/2016)

    The database principal has granted or denied permissions to objects in the database

    and cannot be dropped. (Microsoft SQL Server, Error: 15284)

    The part above...

    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.

    March 28, 2016 at 7:59 am

    #1867975

  • RE: MSDTC / AlwaysOn

    Well we do use MSDTC quite regularly so it's good to hear that there is a solution. Thank you for posting the details.

    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.

    March 28, 2016 at 7:38 am

    #1867965

  • RE: SSMS connecting to SSIS with message Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

    Last question then. Are you using Bulk Insert tasks that are failing or is it the whole package with other tasks that are failing on connection?

    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.

    March 28, 2016 at 6:30 am

    #1867936

  • RE: SSIS import of multiple, variably named CSV files

    webrunner (3/25/2016)

    Hello experts,

    ...

    1. Each morning, a script places 3 files in a share on a db server:

    File_Name1_MM-DD-YYYY-NN

    File_Name2_MM-DD-YYYY-NN

    File_Name3_MM-DD-YYYY-NN

    2. Additionally, at some point during the day, someone will request for one or...

    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.

    March 28, 2016 at 5:26 am

    #1867930

  • RE: SSMS connecting to SSIS with message Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

    Another thought. Have you verified that the server accepts remote connections?

    That's my suspicion if the only time it works is when you are on the server itself. On your desktop,...

    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.

    March 28, 2016 at 5:13 am

    #1867929

  • RE: Login can't be deleted because it granted permissions

    Jon.Morisi (3/25/2016)

    It is a db_owner in the database

    are you trying to delete the actual owner of the database?

    No. The databases are owned by my user name. I'm trying to drop...

    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.

    March 28, 2016 at 4:18 am

    #1867923

Viewing 15 posts - 1,906 through 1,920 (of 9,720 total)