Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 9,715 total)

  • RE: Finding Unused Database Roles

    Your Name Here (7/24/2012)

    Brandie

    Thanks for the script - I'm sure it'll come in handy. One FYI though: the dynamic SQL didn't handle collation conflicts (doggone that ReportServer db... <grin>)....

    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 24, 2012 at 6:59 am

    #1516757

  • RE: SSIS Script Task - Reference Build Error Message

    Fixed!

    Resolved the problem by editing the script, opening up Project Explorer, right-clicking References and adding a Reference to Microsoft.Office.Interop.Excel.

    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 24, 2012 at 6:16 am

    #1516738

  • RE: Are the posted questions getting worse?

    rodjkidd (7/24/2012)

    While waiting for some reasonable sized databases to back up before doing some upgrades, I finally managed to have a stab at answering a question today. No one else...

    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 24, 2012 at 4:36 am

    #1516701

  • RE: Developer Edition

    You're welcome. Let us know if you need anything else.

    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 24, 2012 at 4:33 am

    #1516698

  • RE: Log Shipping Skipping Files With Different Naming Convention

    Andrew Cruz-Moores (7/23/2012)

    Greetings All!

    I have log shipping configured between a primary and secondary server. The secondary server will not restore files if they are not in the files name...

    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, 2012 at 12:10 pm

    #1516406

  • RE: Help with memory usage.

    Are you running SQL on a virtual machine?

    I'm wondering if there are several SQL installs on the physical box in question and memory used by others is reflecting in 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.

    July 23, 2012 at 12:05 pm

    #1516399

  • RE: Difference between list and group in ssrs

    This one can be answered by using Google or Books Online. If you don't have Books Online, grab your install DVD (or .msi) and add it to your client tools...

    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, 2012 at 12:03 pm

    #1516397

  • RE: hwo to create cube using adventure work Dw

    Microsoft's own online tutorial for SSAS: http://technet.microsoft.com/en-us/library/ms170208.aspx

    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, 2012 at 12:02 pm

    #1516395

  • RE: Developer Edition

    Lynn Pettis (7/23/2012)

    SQLRNNR (7/23/2012)

    Just grant them access to the Dev instance on the server rather than RDP. Then install management tools on their desktops and allow them to use...

    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, 2012 at 12:00 pm

    #1516393

  • RE: import data problem in SQL server 2008

    If this webhosting needs database restores, you really need to contact your DBA team. Obviously they didn't set up the correct permissions and they need to if you want 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.

    July 23, 2012 at 8:39 am

    #1516277

  • RE: Weird Error

    Stefan Krzywicki (7/23/2012)

    Trace is likely my only hope.

    "Help me, Obi-Wan Tracenobi. You're my only hope!"

    Running away now. @=)

    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, 2012 at 8:34 am

    #1516272

  • RE: My DOUBT ..Please clarify

    Thank you, Lokesh. @=) Much appreciated.

    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, 2012 at 8:33 am

    #1516271

  • RE: Weird Error

    Wow. Okay. That is odd.

    I honestly don't know what to advise that hasn't already been suggestion. Sorry.

    EDIT: Except to ask... Are you positive that the job steps are calling against...

    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, 2012 at 8:18 am

    #1516254

  • RE: import data problem in SQL server 2008

    ali.mahmoud.habib (7/23/2012)

    PaulB-TheOneAndOnly (7/23/2012)

    Do not use export/import wizard, script your data load - first do your parent tables then your child tables as defined by Referential Integrity constraints.

    An alternative would be...

    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, 2012 at 8:17 am

    #1516253

  • RE: Starting SQL services - Best practise

    GilaMonster (7/23/2012)

    Only time there is a recommended route to stop/start is when it's a clustered instance and in that case you should use cluster admin.

    And if you don't, Bad Things...

    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, 2012 at 8:11 am

    #1516248

Viewing 15 posts - 4,141 through 4,155 (of 9,715 total)