Forum Replies Created

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

  • 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.

  • RE: Are the posted questions getting worse?

    I could listen to Brian Knight talk about SSAS all day and still have to re-review all my notes to get half of what he's explaining to his class.

    I'm glad...

    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?

    Kiara (3/17/2011)


    Referring to your own writing is just common sense. No different than reviewing your own notes on a topic. *Creepy* is when you google something that you don't know...

    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)


    Ok, I'm using sp_send_dbmail but the if my maintenance plain is creating a text document with the date and a runtime as the name of the file how do...

    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,722 total)