Forum Replies Created

Viewing 15 posts - 7,996 through 8,010 (of 9,720 total)

  • RE: Different owner on the logshipped database

    Norecovery isn't going to help you. It'll leave the db in the same state as it is now. "Restoring".

    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 3, 2010 at 4:41 am

    #1161176

  • RE: SQL error on SELECT - MSG4104

    CirquedeSQLeil (5/1/2010)

    Another problem with defining the join as such is the problem of a Cartesian product. Explicitly telling the system to use an Inner join and which fields 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 3, 2010 at 4:38 am

    #1161173

  • RE: One user permissions not working

    nathan 7372 (4/30/2010)

    I considered the conflicting permissions idea. The probelm with that is she is a member of the same domain groups as many other users.

    And what has this...

    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 3, 2010 at 4:35 am

    #1161172

  • RE: Monitoring - How to Alert The DBA when the Failure is at the Server level

    Glad I could help. Sounds like you're on the right track for your job.

    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.

    April 30, 2010 at 10:27 am

    #1160579

  • RE: compact database backups

    RapidShare and BitTorrent aren't about compressing the file. They're about passing files over the Internet in smaller bits and pieces so it doesn't necessarily take so long to get 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.

    April 30, 2010 at 10:25 am

    #1160577

  • RE: One user permissions not working

    Broken ownership chains can also cause security problems.

    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.

    April 30, 2010 at 9:06 am

    #1160509

  • RE: compact database backups

    The websites are restricted from my workplace (I can't see them). But go to RapidShare.com and see if it has any information on private implementation. I know a couple of...

    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.

    April 30, 2010 at 8:56 am

    #1160499

  • RE: compact database backups

    What you need is software similar to Bit Torrent or RapidShare without the file share being publically available for just anyone.

    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.

    April 30, 2010 at 8:42 am

    #1160486

  • RE: Adding unique constraint.

    Cory,

    Who told you that you could be logical about the questions answered on the forum???

    @=)

    Honestly, that possibility didn't occur to me. Retaining old data but forcing new data to be...

    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.

    April 30, 2010 at 8:25 am

    #1160453

  • RE: Deny Select Permission. Can't remember off my head.

    Then the answer is "Yes, he should be able to see the view" with a caveat. He MUST be granted SELECT permissions on the View itself. Otherwise, it will fail.

    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.

    April 30, 2010 at 8:21 am

    #1160452

  • RE: compact database backups

    Litespeed has adjustable compression. It can go pretty small.

    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.

    April 30, 2010 at 6:54 am

    #1160366

  • RE: compact database backups

    Third party tools such as Litespeed can do it for SQL 2005.

    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.

    April 30, 2010 at 6:51 am

    #1160362

  • RE: How to create new instance in sql server 2005

    manoj2001 (7/9/2009)

    But if i am not wrong we could add instances in SQL Server 2000, by right clicking

    enterprise manager and create and register new instance by giving name of 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.

    April 30, 2010 at 6:34 am

    #1160351

  • RE: Monitoring - How to Alert The DBA when the Failure is at the Server level

    One of our corporate teams monitors that sort of thing for us (Server is offsite) and notified us of these problems. Some alerts are auto, some are manual.

    Our cluster service...

    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.

    April 30, 2010 at 6:28 am

    #1160346

  • RE: SQL error on SELECT - MSG4104

    Wow. I need to add an example like this into my SQL Saturday JOINS class.

    Good catch, Jason.

    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.

    April 30, 2010 at 6:23 am

    #1160345

Viewing 15 posts - 7,996 through 8,010 (of 9,720 total)