Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 9,715 total)

  • RE: db_backupoperator can't back up database

    Lynn Pettis (4/26/2016)


    Found this doing a search:

    If you will assign user as db_backupoperator you will discover error when you will try to create a backup..

    When trying to specify location, you...

  • RE: db_backupoperator can't back up database

    Steve Jones - SSC Editor (4/26/2016)


    Log

    user_name()

    suser_sname()

    etc. (there are a few more)

    into a table before the app runs the command (and the command). Check there isn't any impersonation.

    We...

  • RE: db_backupoperator can't back up database

    There were no deny perms initially. I double-checked, there are none now.

    Any other ideas?

  • RE: Are the posted questions getting worse?

    Oh, here's two in German that I learned from a coworker when I was in high school.

    Er/Sie hat nicht alle tasse im Shrank.

    and

    Du hast ein Vogel.

    Roughly translated as "He/She doesn't...

  • RE: Are the posted questions getting worse?

    J Livingston SQL (4/25/2016)


    BWFC (4/25/2016)


    Luis Cazares (4/25/2016)


    Ed Wagner (4/25/2016)


    Jeff Moden (4/24/2016)


    TomThomson (4/22/2016)


    Phil Parkin (4/22/2016)


    Eirikur Eiriksson (4/22/2016)


    Brandie Tarvin (4/22/2016)


    In this case I did add my two cents because I've seen that...

  • RE: Visual Studio and SSIS package / solution question

    frederico_fonseca (4/22/2016)


    Installing Visual Studio 2015 does not prevent you from installing Sql Server Data Tools for visual studio 2012 or 2013 - you can have all 3 versions installed of...

  • RE: Are the posted questions getting worse?

    In this case I did add my two cents because I've seen that damn failure before and it took me days to figure out what the issue was the first...

  • RE: SSIS Packages Job fails no information in Job History

    The most common cause of a TRUNCATE TABLE failure is the login running the code doesn't have db_owner on the database or ALTER permissions on the database. ISTR that even...

  • RE: How do I install AdventureWorks in my local PC

    Good to know! Glad you got it working too.

  • RE: How do I install AdventureWorks in my local PC

    mw112009 (4/22/2016)


    The person sitting next to me has access to his local machine.

    I think the issue is because I have the STANDARD edition.

    The person next to me updated his to...

  • RE: Visual Studio and SSIS package / solution question

    roni.vered (4/22/2016)


    Hi there,

    For "SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI)", it was declared that the SSIS solutions will ONLY work on SQL Server 2014...

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (4/21/2016)


    Brandie Tarvin (4/21/2016)


    Luis Cazares (4/21/2016)


    BLOB_EATER (4/21/2016)


    Luis Cazares (4/21/2016)


    Brandie Tarvin (4/21/2016)


    Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread...

  • RE: Are the posted questions getting worse?

    Luis Cazares (4/21/2016)


    BLOB_EATER (4/21/2016)


    Luis Cazares (4/21/2016)


    Brandie Tarvin (4/21/2016)


    Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops up in...

  • RE: Are the posted questions getting worse?

    Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops up in Google is a thread I posted about...

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/19/2016)


    Personally, this strikes me as more interesting!

    /* Version number binary from daily registy */

    DECLARE @VERSION_STRING VARBINARY(max) = 0x6E7976777926807C71767771798078697977337C35778938398D3B8B8F80408F9594848597949C8E9B978F929293A2A5A05253A19A9AA6999E9FA05CA1B0A4B261A3;

    --DECLARE @VERSION_STRING VARBINARY(max) = 0x4D5544532556564C5B504C552D675B;

    /* Inline Tally for parsing...

Viewing 15 posts - 1,816 through 1,830 (of 9,715 total)