Forum Replies Created

Viewing 15 posts - 7,786 through 7,800 (of 9,715 total)

  • RE: Today's Random Word!

    Kit G (7/30/2010)


    Brandie Tarvin (7/30/2010)


    FLORIDA! 😛

    'Nuff said, yes?

    (mugginess wimps. @=)

    Bah. You want mugginess, check out Houston, TX in the summer. UGH. Tampa is nice compared 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.

  • RE: Truncate rollback

    saagrawal (7/30/2010)


    it is working opposite to my knowledge.

    Where did you read that you can't rollback a truncate? Do you have specific sources?

    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.

  • RE: Today's Random Word!

    FLORIDA! 😛

    'Nuff said, yes?

    (mugginess wimps. @=)

    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.

  • RE: Sysprocesses Question

    Look up 'sysprocess system table' in Books Online.

    BOL


    stmt_start

    Starting offset of the current SQL statement for the specified sql_handle.

    stmt_end

    Ending offset of the current SQL statement for...

    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.

  • RE: Connections & Sessions

    Each window is a separate session. And since you're not doing much of anything else, there's only 1 connection per session.

    EDIT: Each session has a minimum of 1 connection per...

    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.

  • RE: Password change error

    sushantkumar1984 (7/29/2010)


    that section is unchecked.

    Then it's time to crack open the application code and see what the login module is trying to do. You need to debug it (or 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.

  • RE: Password change error

    sushantkumar1984 (7/29/2010)


    The app allows changing of password as it is enabled in sql 2005 to enforce password policy.

    Just so you know, these are NOT the same thing. If the application...

    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.

  • RE: Buffer Pool information/usage

    Pam Brisjar (7/29/2010)


    Processor tab: affinities automatic max threads 0, boost priority not set

    Nothing else runs on this machine other than the standard server things.

    But you're having performance issues still....

    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.

  • RE: Today's Random Word!

    dbowlin (7/29/2010)


    John Rowan (7/29/2010)


    I knew that dbcc timewarp would be the secret to our success!

    Yes, but let's keep it a secret, lest we anger the TSF (Temporal Security Forces) 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.

  • RE: Sysprocesses Question

    stmt_start and stmt_end means when the query started running and when it stopped running.

    Look up Profiler in BOL. All your column names are similar enough events & columns in...

    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.

  • RE: Password change error

    Was the login able to log into the system before the change password attempt? Is it still able to login now? (Just verifying the change is the only thing you've...

    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.

  • RE: Buffer Pool information/usage

    Whoops, I must have mixed up those two fields when I read the snippet. My bad.

    What is the priority on your Server Properties Processors tab? And what else do 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.

  • RE: Are the posted questions getting worse?

    GilaMonster (7/29/2010)


    If you look, it didn't go suspect. It went recovery_pending. That's because the corruption was encountered while opening the file. To get it suspect, the corruption has 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.

  • RE: linked server catalogs not showing on client SSMS.

    Dana Bibeault (7/29/2010)


    Can't see them in the user GUI. I can see them as administrator on my gui and on the server.

    strangely, if the user goes to another PC,...

    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.

  • RE: Are the posted questions getting worse?

    GilaMonster (7/29/2010)


    Results of test:

    ....

    If you're interested in repo:

    ....

    -- open mdf in hex editor at this point and overwrite part of the first couple pages.

    Is this what you did 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.

Viewing 15 posts - 7,786 through 7,800 (of 9,715 total)