Forum Replies Created

Viewing 15 posts - 7,966 through 7,980 (of 9,725 total)

  • 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

  • RE: Error in SSIS Package

    Paul_Harvey (5/7/2010)

    It seems add that simply setting the RetainSameConnection to True would cause a permissions error.

    I've never actually seen that error before, and I've used the RetainSameConnection property. But never...

    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:50 am

    #1163971

  • RE: Tempdb GROWS

    Is this query yours or does it belong to the vendor?

    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:00 am

    #1163950

  • RE: Tempdb GROWS

    The number of times a query runs doesn't mean anything. What matters is the number of reads, writes, and recompiles. Also the length of time a query runs.

    I'll take a...

    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 4:56 am

    #1163947

  • RE: Timout expired when logging in from client SSMS

    Are you running a clustered server environment? Does your network use a foundary for passing up connections to the cluster?

    We've had issues with our foundary where it would keep routing...

    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 6, 2010 at 5:57 am

    #1163091

  • RE: Can't lauch SQL Server Managment Studio after i am connected via VPN

    nana.asare (5/5/2010)

    i have attached a screen shot of the error i got to my reply

    Read the error carefully. See where it says "or Remote connections are not allowed?"

    Brandie Tarvin (4/29/2010)

    Check...

    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 6, 2010 at 4:27 am

    #1163051

Viewing 15 posts - 7,966 through 7,980 (of 9,725 total)