SQL Server 2008 DBA Training Video: Misc Bits: NO_WAIT, ROLLBACK AFTER, ROLLBACK IMMEDIATE

Misc Bits: NO_WAIT, ROLLBACK AFTER, ROLLBACK IMMEDIATE - view details
In this demo video we will revisit a few commands that we've talked about in a previous chapter that we will use more heavily in later parts of this course. These commands are the alter database commands.

Highlights from this video:

Effects of the WITH ROLLBACK IMMEDIATE statement
How WITH ROLLBACK AFTER x SECONDS works
What is the WITH NO_WAIT command?
Example of working with the commandsand much more Source: http://www.learnitfirst.com/Course/157/Video/1836/Miscellaneous-ROLLBACK-Commands.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 300 (Intermediate) Length: 5:45 (9.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: NO_WAIT, ROLLBACK, backup,restore,sql server,2008

This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.