Forum Replies Created

Viewing 15 posts - 7,891 through 7,905 (of 9,720 total)

  • RE: SQL Server 2005 crashes sometimes

    samiam914 (6/14/2010)

    I am having trouble with linked server. In this linked server, only one windows ID is mapped to an Oracle ID ... it's password does not conform to windows...

    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.

    June 16, 2010 at 6:29 am

    #1180910

  • RE: Published again

    Spiritual support is also acceptible. But when you do get back into gaming... @=)

    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.

    June 14, 2010 at 7:26 am

    #1179845

  • RE: SQL Server 2005 crashes sometimes

    It's not services you necessarily have to worry about. It's all the little things, like Linked Servers, jobs or SSIS packages that specifically call those accounts, etc.

    The only way 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.

    June 14, 2010 at 4:44 am

    #1179750

  • RE: Mirroring connection timeout for db

    Are your servers within the same domain and both inside the firewall?

    If not, is your firewall open to the ports being used in the mirroring?

    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.

    June 14, 2010 at 4:39 am

    #1179747

  • RE: SSMS Crashes When Designing View

    Crashes as in it brings SSMS down or freezes SSMS or what?

    Describe what happens step-by-step please.

    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.

    June 11, 2010 at 11:58 am

    #1179357

  • RE: SQL Server 2005 crashes sometimes

    samiam914 (6/11/2010)

    They decided to implement password change enforcement every six months in windows, which kicked in on June 1st. Operations put in changes to enforce password changes.

    Do these password changes...

    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.

    June 11, 2010 at 11:50 am

    #1179349

  • RE: Mirroring connection timeout for db

    I don't use Data Mirroring so I couldn't even begin to answer that question. Sorry.

    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.

    June 9, 2010 at 11:11 am

    #1178136

  • RE: Proxy accounts and principles

    I don't use proxies, so I'm just guessing that your problem is the underlined one...

    This is what I found in BOL.

    Books Online

    SQL Server Agent proxies use credentials to store information...

    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.

    June 9, 2010 at 4:39 am

    #1177894

  • RE: Mirroring connection timeout for db

    Marios Philippopoulos (6/8/2010)

    Having been burnt several times already by the error in the OP, I set the timeout to 60 seconds.

    Is there a downside to setting it that high?

    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.

    June 9, 2010 at 4:20 am

    #1177887

  • RE: Patching SQL Server 2005 past SP3?

    SP4? Whoohoo!

    And here I thought they weren't planning any more SPs for 2k5.

    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.

    June 4, 2010 at 5:01 am

    #1176449

  • RE: Patching SQL Server 2005 past SP3?

    That's Microsoft standard warning on all hot fixes and CPs. They don't want to take responsibility for Bad Things happening to your server if you put something on it 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.

    June 3, 2010 at 12:42 pm

    #1176128

  • RE: System cache eating into SQL memory

    RE: Lock Pages in Memory. We have it set on our prod server and it hasn't caused any problems. I've never heard of the situation you've referenced, though.

    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.

    June 3, 2010 at 12:40 pm

    #1176124

  • RE: System cache eating into SQL memory

    Just keep watching it. Also, write down what times of day you're seeing this stuff happen. Maybe it's happening at the same time every day and that'll help you narrow...

    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.

    June 3, 2010 at 8:51 am

    #1176006

  • RE: Automating job scripts

    Glad we could help. 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.

    June 3, 2010 at 8:19 am

    #1175976

  • RE: System cache eating into SQL memory

    You have to make sure both are running at the same time. When both are done, open up Profiler and import the server side trace. Then go to 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.

    June 3, 2010 at 8:03 am

    #1175964

Viewing 15 posts - 7,891 through 7,905 (of 9,720 total)