Forum Replies Created

Viewing 15 posts - 3,031 through 3,045 (of 9,725 total)

  • RE: Need help with SSIS Security walk through

    Oh, for heaven's sake. After all this grief with the job and the task, it turns out the problem is the file isn't zipping up properly because a .lst file...

    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.

    December 11, 2014 at 6:39 am

    #1764025

  • RE: Database Specific Access

    Did you upgrade from SQL 2005 or SQL 2000? It might be a holdover from one of those.

    Also, it is entirely possible the login was orphaned (the server level login...

    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.

    December 11, 2014 at 6:16 am

    #1764018

  • RE: Drive Spaces - Database size

    I calculate it based on what the database seems to need.

    Are you creating new databases or trying to calculate this for existing databases?

    Also, what you really need to know 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.

    December 11, 2014 at 6:14 am

    #1764017

  • RE: SQL DBA knowing user passwords

    Eric M Russell (12/10/2014)

    lshanahan (11/26/2014)

    Markus (11/25/2014)

    You guys must live in a perfect world of applications... However, the bulk of the SQL Server based apps are small companies and don't have...

    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.

    December 10, 2014 at 12:12 pm

    #1763870

  • RE: Linked Server not reading

    William Assaf (12/9/2014)

    I know this is delayed, but I just tangentially heard about this problem.

    I bet it's permissions.

    From MSDN:

    http://msdn.microsoft.com/en-us/library/ms187354.aspx

    "Only members of sysadmin can modify a schedule owned by another...

    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.

    December 10, 2014 at 4:30 am

    #1763733

  • RE: Using SSIS

    jimmyjjohns08 (12/7/2014)

    On every machine where you want to run an SSIS package, you need to install the Integration Services components, using the SQL Server media.

    That's not what he is doing,...

    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.

    December 9, 2014 at 4:22 am

    #1763466

  • RE: Using SSIS

    psc032802 (12/5/2014)

    Yes, I see the viewer installed on my computer.

    I do not have much access overall. Just read access to one database and I cannot see what...

    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.

    December 5, 2014 at 11:43 am

    #1763051

  • RE: Are the posted questions getting worse?

    Ed Wagner (12/5/2014)

    Brandie Tarvin (12/5/2014)

    GilaMonster (12/5/2014)

    And crisis, panic, run around screaming, the EF-based app is slow.

    600MB database, generating 5GB of trace data in 1 hour....

    Here's a bit of easy...

    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.

    December 5, 2014 at 5:31 am

    #1762931

  • RE: Using SSIS

    psc032802 (12/4/2014)

    Thanks for the good info. If data profile tasks is all I need, then I ask the DBA to have it run on regular schedule. If they...

    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.

    December 5, 2014 at 4:52 am

    #1762917

  • RE: Are the posted questions getting worse?

    GilaMonster (12/5/2014)

    And crisis, panic, run around screaming, the EF-based app is slow.

    600MB database, generating 5GB of trace data in 1 hour....

    Here's a bit of easy code to solve 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.

    December 5, 2014 at 4:48 am

    #1762916

  • RE: SQL DBA knowing user passwords

    Eric M Russell (12/4/2014)

    I get the impression this is not commonly known, but a SQL Server authenticated user account, even a minimal user with nothing but default public permissions, 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.

    December 4, 2014 at 7:24 am

    #1762706

  • RE: SQL DBA knowing user passwords

    Ville-Pekka Vahteala (12/3/2014)

    ScottPletcher (12/2/2014)

    eric.notheisen (12/2/2014)

    In our company sharing user passwords is a firing offense. As developers needing to troubleshoot user defined defects, we restore the production database to our...

    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.

    December 4, 2014 at 6:05 am

    #1762691

  • RE: Using SSIS

    jliu 81028 (12/3/2014)

    Your number 3 option should work for me:

    3) Ask to have the SQL Server client tools installed on your machine (including BIDS) and create the package yourself. Ask...

    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.

    December 3, 2014 at 10:18 am

    #1762458

  • RE: Using SSIS

    jliu 81028 (12/3/2014)

    thanks for replying me again. if I ask my dba to install BIDS on machine, what do you think he'll be concerned about? security? my skill/knowledge of SSIS?

    I...

    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.

    December 3, 2014 at 9:57 am

    #1762452

  • RE: Using SSIS

    psc032802 (12/3/2014)

    I am not a DBA. Not a developer either. More of an end user of the data typically analyzing it.

    I'm mostly interested in the data profile task...

    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.

    December 3, 2014 at 9:56 am

    #1762451

Viewing 15 posts - 3,031 through 3,045 (of 9,725 total)