Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DA(blog.sqlauthority.com)

submitted by pinaldavepinaldave(9662) 2 years, 2 months ago

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE March 17, 2010 by pinaldave | Edit Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE. The first one is ALTER DATABASE …ROLLBACK IMMEDIATE and the second one is WITH NO_WAIT.

add a comment |category: |Views: 118

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:
information Login or create an account to comment on this story