Well, thanks for the clarification. I was studying for the MCTS exam using 'The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit: Database Implementation and Maintenance' by Mark Horninger...

Sure, I agree that its easier to run a script than to click through a wizard every time. But if the user uses the wizard only once, configuring the backup...

Can you explain why your script is better than just using the SSMS Maintenance Plan Wizard?

Thanks,

I agree with the others that this is not a good question, or the answer should be True. As others have pointed out that you can use T-Sql within SSMS....

It would be helpful if the Author added comments to the article and code, including what version he/she created this on and on what versions it is known to work....

Sorry for joining this conversation late...

Is there something missing in the code when you are setting the XML variable:

declare @xmlvar1 xml;

declare @emp table (emp_id int primary key);

set @xmlvar1 = '...

Ok... I guess I didn't really understand how the uniqueidentifier is generated - looks like it involves a sort of hex timestamp for the first 4 octets.

Thanks!

I think I'm missing something too...

The purpose of the newsequentialid() is to be sequential in the context of a given table, yes? Therefore the SP would need to know the...

Paul Randal (4/1/2010)

So you're trying to learn Greek (or pick any language you don't know), and its very frustrating...

Not funny. Not being a database guru, I try to read and understand these articles when I get the chance to become more proficient, but rarely do I have the...