Sigh, I sure like the days when the QOD is not specific to SQL2005, then I might get one right. Someday I will upgrade, I promise.

</Flamesuit ON>

Maybe you are not trying this in SQL 2005. If I remember correctly, the TRY CATCH block is new in 2005.

OK, I'm confused by the explanation:

Explanation:

D gives the correct syntax for the script component.

How is that if "C" is the right answer? Am I just experiencing coffee withdrawls this...

I was hoping for a way to script a procedure using TSQL. Using the Object Browser in QA would not be much different than using EM.

I was thinking something like...

I use EM for two functions that I do quite often, creating databases and scripting store procedures.

I know that it is fairly simple to create a db in TSQL, I...

So, what exactly is a Synchronous Script Transform?