Microsoft introduced Snippets and Surround With in SQL Server 2012. In this post we can see how to use those both options. And how to create User Defined Snippets....

Maurice, What you see is the expected behaviour because the XML data type does not preserve CDATA section. This is a limitation in the current release and I really wish future releases may remove this....

Does creating a primary key always create a clustered index? Can a clustered index be created using a column other than the primary key? SQL Server has not such relation/rule between primary keys and clustered indexes....

...

yes, it exists in SSMS 2008, however, the UI is slightly different, which may have caused the confusion. ![alt text][1] [1]: http://media.beyondrelational.com/images.ashx?id=33bf637205d24342a40b20c403dc0dfa&w=-1&h=-1...

@woodymax, I am glad to know that you liked this post. Thank you....

It is also an XSD editor that allows you to create XML Schema Definitions, with intellisense and real-time validations. It also has the capability to auto-generate the schema of an XML document/fragment. Unfortunately, there does not seem to be a si...

Did you know that the SQL Server Management Studio (SSMS) has a built-in XML editor? Chances are that you launch the Visual Studio IDE to edit XML documents even though the SSMS is up and ready to go. Learn about the underappreciated XML editor feature ...

...

If this column is not bound to a schema, then this declaration is harmless. That is used to uniquely identify the elements and attributes within the XML document, just like you alias a table What is the reason why you wanted to auto generate a schema...