Forum Replies Created

Viewing 15 posts - 8,206 through 8,220 (of 9,725 total)

  • RE: Just SQL Auth

    Maybe I'm smoking something, but isn't SQL Server--and many things it now does--so tightly integrated into the OS that if Windows Authentication were removeable, it would break most of SQL...

    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.

    November 20, 2009 at 5:09 am

    #1082112

  • RE: Transactions & Cursors

    Thanks, Garadin, for both the response and the test code. It's 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.

    November 20, 2009 at 4:47 am

    #1082103

  • RE: why i can't shrink tempdb data file

    Microsoft has responded to that feedback thread with a request for more information. Were you the one who posted it?

    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.

    November 20, 2009 at 4:11 am

    #1082089

  • RE: why i can't shrink tempdb data file

    briansalentine (11/19/2009)

    I found that a department was running reports for a very large date range, so, this brought our normally 7GB- 10GB database up quite a bit. We basically...

    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.

    November 19, 2009 at 10:47 am

    #1081719

  • RE: Speed Phreaks

    This topic is also for those of us serving in the "Jack-of-All-DBA-Jobs" role. @=)

    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.

    November 19, 2009 at 10:43 am

    #1081717

  • RE: xpsmtp80.dll PROBLEMS

    Did you try the solution I posted above?

    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.

    November 19, 2009 at 10:41 am

    #1081714

  • RE: Attach/Dettach - automate

    And if this sort of thing will happen more than once, consider storing your .mdf and .ldf names in a table on a database that doesn't tend to get moved....

    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.

    November 18, 2009 at 1:14 pm

    #1081173

  • RE: Speed Phreaks

    Sorry, GSquared. I have an anti-ditto (of a sort) to your list.

    RE: Indexing. Yes, index. But don't OVER index.

    Pet Peeve = developers add an index to an existing table just...

    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.

    November 18, 2009 at 8:49 am

    #1080966

  • RE: Commvault backup tool creates proprietary backup files

    Ah, I misunderstood your post.

    Good luck with the battle.

    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.

    November 5, 2009 at 7:44 am

    #1075339

  • RE: Commvault backup tool creates proprietary backup files

    If you're the network tech, why are you responsible for the log shipping? I would think that it (and testing backup software) would be the responsibility of the DBA team.

    Unless...

    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.

    November 5, 2009 at 7:01 am

    #1075311

  • RE: Problem to transfer database user, when restoring a backup

    First look up CREATE LOGIN, CREATE USER and sp_addrolemember in BOL (Books Online). This will give you all the syntax you need.

    Dynamic SQL is the act of putting SQL...

    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.

    November 5, 2009 at 6:34 am

    #1075299

  • RE: Commvault backup tool creates proprietary backup files

    The problems with any backup tool is that if it breaks or you lose your license, you have all these backups you may not be able to restore if 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.

    November 5, 2009 at 6:28 am

    #1075296

  • RE: Problem to transfer database user, when restoring a backup

    One by one? Ah, you need to be more creative. @=)

    If you can only "fix" certain users, try putting the specific logins in a table on a DBA only database...

    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.

    November 5, 2009 at 6:01 am

    #1075284

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

    Thanks, Gail. I'm patient and any new links you have would be greatly appreciated. FYI, looking at your very first link above, I found my answer.

    The transaction log has...

    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.

    November 5, 2009 at 5:34 am

    #1075271

  • RE: SQL INJECTION

    I'm sorry, but I'm still not clear on what you want to accomplish. Could you be more detailed?

    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.

    November 5, 2009 at 5:22 am

    #1075262

Viewing 15 posts - 8,206 through 8,220 (of 9,725 total)