Forum Replies Created

Viewing 15 posts - 7,951 through 7,965 (of 9,715 total)

  • RE: Maintenance plan backup issue

    Try this from different workstations and from the server directly. Do you still get the same error?

    What edition & version (including service packs) of SQL Server are you using?

    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.

    May 12, 2010 at 11:12 am

    #1166398

  • RE: Do you know your getdate()?

    If someone asked me about the accuracy in an interview, my response would be "I don't know. I've never needed GetDate() or related functions to be that precise. If and...

    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.

    May 12, 2010 at 10:33 am

    #1166365

  • RE: check list for Migrating sql server 2000 to 2005

    GilaMonster (5/12/2010)

    How does a DBA can plan or prepared for such a scenario?????

    Same way you plan for any other scenario. Examine the risks, the chances of it happening, examine 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.

    May 12, 2010 at 7:36 am

    #1166197

  • RE: Tempdb GROWS

    2cams (5/10/2010)

    The vendor thought we were complaining about a performance issue which there was initially. We re indexed the database and updated the stats

    Re-indexed as in recreated the ones that...

    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.

    May 10, 2010 at 8:51 am

    #1165040

  • RE: Tempdb GROWS

    That seems to be an awfully low number of allocated pages. Did you run this after hours or during business hours?

    Also, did you run it while the queries 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.

    May 10, 2010 at 4:46 am

    #1164907

  • RE: Tempdb GROWS

    Ah, I thought it was something specific to the code that you could point me 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.

    May 7, 2010 at 10:31 am

    #1164262

  • RE: Tempdb GROWS

    CirquedeSQLeil (5/7/2010)

    It seems that this statement is causing a lot of page allocations due to the delete statement. I would certainly take it back to the vendor and 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.

    May 7, 2010 at 10:21 am

    #1164244

  • RE: Granting execute rights

    krypto69 (5/7/2010)

    I think I figured it out...

    Could you share so that future readers of this thread know what to look for?

    thanks brandie

    You're quite welcome.

    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.

    May 7, 2010 at 8:42 am

    #1164160

  • RE: Connection string being passed into DTEXEC is not used during execution of package

    rustman (5/7/2010)

    The password will still be visible to someone even if it is passed in during execution either throught the command line or the config files.

    Depends on how that...

    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.

    May 7, 2010 at 8:40 am

    #1164155

  • RE: Error in SSIS Package

    So far as I know, and I could be wrong, you can't Fuzzy Group without a basic Fuzzy Lookup. Which tells me SSIS has a built-in Lookup feature on 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.

    May 7, 2010 at 7:59 am

    #1164111

  • RE: Granting execute rights

    Is the user there or the login there?

    There's a difference. If the login isn't mapped to the database or mapped improperly to the database, then you'll encounter this error.

    "Improperly" 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.

    May 7, 2010 at 7:00 am

    #1164050

  • RE: Tempdb GROWS

    2cams (5/7/2010)

    This is my 1st Tempdb issue so I'm grabbing whatever I can implement easily to help with this issue

    Please don't take this the wrong way...

    Beware the easy out....

    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.

    May 7, 2010 at 6:41 am

    #1164022

  • RE: Tempdb GROWS

    This code hits one of my major pet peeves, which probably doesn't contribute much to your problem but certainly doesn't help it either.

    Allow me to point out a few...

    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.

    May 7, 2010 at 6:33 am

    #1164017

  • RE: Connection string being passed into DTEXEC is not used during execution of package

    gvaldridge (4/30/2010)

    However, if this is working as designed, I guess I'm not sure what the point is in allowing the user to manually enter a Connection String within DTEXEC(UI).

    Elliot 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.

    May 7, 2010 at 6:02 am

    #1163983

  • RE: Connection string being passed into DTEXEC is not used during execution of package

    Edit: Misread original post. Deleting this comment and looking for a better solution.

    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.

    May 7, 2010 at 5:56 am

    #1163975

Viewing 15 posts - 7,951 through 7,965 (of 9,715 total)