Forum Replies Created

Viewing 15 posts - 6,271 through 6,285 (of 9,725 total)

  • RE: 3rd party SQL performance tools worth it for a newbie?

    stebennettsjb, let me ask these questions.

    Who's spending the money to get these tools? And what's the budget?

    And what else would you be doing if you had these tools to "take...

    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: Help me with simple task!!

    Your post title is correct. This is a simple task.

    So why did you post 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.

  • RE: sql 2008 and R2 in 1 machine?

    Gail Shaw recommended that I install regular 2k8 first, then R2 second, just to be on the safe side. I don't know if there are issues, but I'd take her...

    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: R2 problem with SQL Server Agent

    PROGRESS!

    Found the proper log under the directory I set as my default database location.

    ...\R2\MSSQL10_50.SQL2K8_R2\MSSQL\Log

    "SQL Server 2008 SQLServer Error: 65535" comes up with Google links, the first of which is this:

    http://connect.microsoft.com/SQLServer/feedback/details/509930/sql-2008-r2-nov-ctp-cant-start-sql-agent-service-using-domain-account

    I'll...

    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: R2 problem with SQL Server Agent

    HowardW (3/18/2011)


    What does the event viewer message say?

    The Application event says exactly what I posted above, with an event ID of 103, Task Category: Service Control, Keywords: Classic and Detail...

    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: R2 problem with SQL Server Agent

    Steve Jones - SSC Editor (3/18/2011)


    Or check the event logs, usually the security one.

    Not seeing a whole lot under security, except a few messages (about the first time I tried)...

    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: R2 problem with SQL Server Agent

    Thanks, Howard. I have both 2k5 and 2k8 R2 installed on my laptop and I can only find one version of that file, exactly where you said it was. However,...

    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: Deleting a large amount of data from a table

    This is probably a little late for you, but I really wouldn't have used a loop for this delete. I'd have gone with the straight delete, but changed the Archive...

    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!

    Daniel Bowlin (3/18/2011)


    I'm not really paranoid, but people are out to get me. 😀

    Just because I'm paranoid doesn't mean people aren't out to get me.

    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: SQL Mail

    kd11 (3/17/2011)


    The Plain has been created via GUI (Management Studio)

    FYI: It's "plan", not plain. There's no "i" in the word.

    The GUI won't help you with this. None of the available...

    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!

    Relax

    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: SQL Server Conditional Join

    Chris's suggestion was where I was going with my subquery comment.

    Consider also if you'll ever have Opn and Beg as Statuses, or Opn and Pro as opposed to the Beg...

    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 does not return all records.

    kashif.nadeem (3/17/2011)


    3a) Please review your linked server and tell me what security options are set on it. Then, if mapping to a specific login, go to the source database 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: Are the posted questions getting worse?

    Craig Farrell (3/17/2011)


    Annnnd, now I have an image of sheep storming the castle. I wonder if they fit their armor before or after sheerings...

    CRAIG!

    Stop giving me story ideas! 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.

  • RE: Are the posted questions getting worse?

    Tom.Thomson (3/17/2011)


    Jeff Moden (3/16/2011)


    That reminds me... I have to keep reminding my minions... "Pillage first... THEN burn.":-D

    Surely unless your minions are such extreme qermospodiaphiliacs that it distorts their perception they...

    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 - 6,271 through 6,285 (of 9,725 total)