Forum Replies Created

Viewing 15 posts - 8,071 through 8,085 (of 18,926 total)

  • RE: transaction log full

    Apparently you're not to keen on reading full articles which would give you all the info you need to do this job so here's a "safe path"...

    Ask for a maintenance...

    April 25, 2010 at 4:33 pm

    #1157428

  • RE: Truncate rollback

    Tao Klerks (4/23/2010)

    Ninja's_RGR'us (4/23/2010)

    That's an interesting theory, care to script it out and prove it?

    I'm not sure my theory is that interesting, I suspect that I just misunderstood what Hugo...

    April 24, 2010 at 4:53 am

    #1157249

  • RE: Truncate rollback

    Paul White NZ (4/24/2010)

    Always good to see this question - the myth that TRUNCATE TABLE is non-logged (and so cannot be rolled back) is a persistent one.

    Quite clever using 2008-only...

    April 24, 2010 at 4:52 am

    #1157248

  • RE: Truncate rollback

    Tao Klerks (4/23/2010)

    Hugo Kornelis (4/23/2010)

    The log file will contain only the fact that page so-and-so was deallocated, but the log backup (if one is taken) will also include a copy...

    April 23, 2010 at 5:22 pm

    #1157179

  • RE: how to show deleted rows

    Lynn Pettis (4/23/2010)

    For better answers to your questions, please read and follow the instructions given in the first article I reference below in my signature block regarding "asking for help."...

    April 23, 2010 at 2:04 pm

    #1157130

  • RE: Truncate rollback

    Wow 72 posts for this "little" question. I can offically say this the best QOTD I ever posted :w00t::hehe:.

    April 23, 2010 at 2:01 pm

    #1157125

  • RE: Truncate rollback

    David_Simpson (4/22/2010)

    If you really need the points... you can have mine. I've tried spending them at Walmart but they wouldn't take them. 😉

    Speaking of learning something, Paul Randal has...

    April 22, 2010 at 1:20 pm

    #1156394

  • RE: Truncate rollback

    Abrar Ahmad_ (4/22/2010)

    [font="Verdana"]

    Ninja's_RGR'us (4/22/2010)

    Hugo Kornelis (4/22/2010)

    Good question. Not sure why it's worth 2 points; knowing that TRUNCATE can be rolled back should be elementary knowledge.

    Abrar Ahmad_ (4/22/2010)

    [font="Verdana"]Goodish, easy hunt. but...

    April 22, 2010 at 4:48 am

    #1155969

  • RE: Truncate rollback

    Christian Buettner-167247 (4/22/2010)

    The following setting will cause the error:

    SET IMPLICIT_TRANSACTIONS ON

    If this is turned on, the create table statement will also be rolled back, causing the error.

    Thanks I hadn't considered...

    April 22, 2010 at 4:41 am

    #1155966

  • RE: Truncate rollback

    Tom Brown (4/22/2010)

    Useful, if only to learn about the new INSERT syntax

    Cool, I'm glad many of you had a chance to learn 2 things in this question. I...

    April 22, 2010 at 4:36 am

    #1155964

  • RE: Truncate rollback

    Hugo Kornelis (4/22/2010)

    Good question. Not sure why it's worth 2 points; knowing that TRUNCATE can be rolled back should be elementary knowledge.

    Abrar Ahmad_ (4/22/2010)

    [font="Verdana"]Goodish, easy hunt. but for the only...

    April 22, 2010 at 4:33 am

    #1155962

  • RE: What do you do when you don't get paid?

    Michael Valentine Jones (4/21/2010)

    Really late payments and refusal to pay legitimate bills are one of the big warning signs of a company that is about to go bankrupt.

    If they're out...

    April 22, 2010 at 4:29 am

    #1155961

  • RE: What do you do when you don't get paid?

    Jeff Moden (4/21/2010)

    Ninja's_RGR'us (4/21/2010)

    Now the clients wants me to go back as a consultant to keep working on the projects. I refused since it would breach my relationship with...

    April 21, 2010 at 4:23 pm

    #1155749

  • RE: What do you do when you don't get paid?

    CirquedeSQLeil (4/21/2010)

    Very simply deny the work. The thought of shutting down somebody is tantalizing at times as is the extra cash if you thought he would pay.

    However, history says...

    April 21, 2010 at 4:14 pm

    #1155744

  • RE: What do you do when you don't get paid?

    bitbucket-25253 (4/21/2010)

    Your boss ,truly, has only one recourse. Hire a contract lawyer, and consult with that individual, and then decide how to proceed.

    Yup I think this...

    April 21, 2010 at 4:13 pm

    #1155743

Viewing 15 posts - 8,071 through 8,085 (of 18,926 total)