Forum Replies Created

Viewing 15 posts - 5,701 through 5,715 (of 9,715 total)

  • RE: how to prevent startup in single user mode

    So far as I know, there is no way to prevent it. Single User mode is used to prevent additional people from gaining access while certain maintenance activities are occurring....

    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 20, 2011 at 5:47 am

    #1341090

  • RE: how many sql server error logs are there? from within sql.

    Let's start from the beginning. Why do you want to write a script to do this?

    Why can't you just have it read the most recent error log on each...

    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 20, 2011 at 5:44 am

    #1341086

  • RE: Need help for checkdb error

    What Suresh didn't tell you is that databases upgraded to SQL 2005 can experience invalid page and row counts in the system catalog views. DBCC UpdateUsage corrects those counts.

    However, if...

    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 20, 2011 at 5:43 am

    #1341085

  • RE: System Database - MODEL corrupted

    george sibbald (6/15/2011)

    To avoid this problem in the future, next time your instance is down take a flat file copy of the system database files to another directory (including 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.

    June 20, 2011 at 5:39 am

    #1341079

  • RE: How to remove duplicates from column without using Temp table

    Hashbytes seems overly complicated to me as well.

    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 20, 2011 at 5:14 am

    #1341055

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (6/17/2011)

    Cross your fingers, everyone. Horse vet called, ugly cut on the rear hind of a horse. I think it can be stitched, but you 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.

    June 20, 2011 at 5:07 am

    #1341050

  • RE: Backup Duration

    GilaMonster (6/17/2011)

    Which would you prefer?

    1) Finding out the backup is damaged and unrestorable right after making it, when you can make another

    2) Finding out the backup is damaged after 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.

    June 20, 2011 at 5:04 am

    #1341045

  • RE: Datetime Conversion Issue in SSIS - Need Help

    paul.knibbs (6/20/2011)

    But if the Sybase DATETIME is only accurate to 1/300th of a second, it CAN'T be using any old values for the thousandths--0.001 would make no sense because 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.

    June 20, 2011 at 5:01 am

    #1341043

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/17/2011)

    Brandie Tarvin (6/17/2011)

    Wow. PASS people have been busy the past two weeks. I've gotten more SQL Saturday speaker request notifications than I can shake a stick at!

    Yeah it seems...

    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 17, 2011 at 12:36 pm

    #1340664

  • RE: Are the posted questions getting worse?

    Wow. PASS people have been busy the past two weeks. I've gotten more SQL Saturday speaker request notifications than I can shake a stick at!

    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 17, 2011 at 12:32 pm

    #1340660

  • RE: Are the posted questions getting worse?

    GilaMonster (6/17/2011)

    Off to the UK for a week and a half. Can some people keep an eye on the corruption forums make sure that any problems don't get unchallenged stupid...

    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 17, 2011 at 12:31 pm

    #1340657

  • RE: Are the posted questions getting worse?

    Kiara (6/17/2011)

    Brandie Tarvin (6/17/2011)

    Kiara (6/17/2011)

    Totally off the security rights topic... can anyone point me in the right direction to get some information on realistic salary levels in the US 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.

    June 17, 2011 at 10:46 am

    #1340593

  • RE: Are the posted questions getting worse?

    Kiara (6/17/2011)

    Totally off the security rights topic... can anyone point me in the right direction to get some information on realistic salary levels in the US for SSRS developers?

    Salary.com 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.

    June 17, 2011 at 10:39 am

    #1340584

  • RE: PerfectDisk Vs DisKeeper

    damiang (6/17/2011)

    I'm the Product Manager for Diskeeper Corporation, & want to speak to some of the questions posed directly.

    That is a very well written post. Thank you for putting up...

    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 17, 2011 at 10:35 am

    #1340579

  • RE: temp table in user database?

    glen.wass (6/17/2011)

    HI, try looking up variable temp tables, as i understand it these work from memory however, i do think that there is a limit to the amount of data...

    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 17, 2011 at 10:33 am

    #1340578

Viewing 15 posts - 5,701 through 5,715 (of 9,715 total)