In this doc: http://msdn.microsoft.com/library/?url=/library/en-us/tsqlref/ts_setu-sus_4stw.asp?frame=true  it states in the remarks area, that the SQL_VARIANT type can only support up to 8016 bytes.  Thus, you can eliminate all of the types...

The XML datatype will strip out spaces in the xml document not related to content (so between tags etc) which is a change to the document.  The question is asking...

To execute the second part of the stored procedure you need to include the 2.

exec SelectTest -- will return the select from the first query

exec SelectTest;2 -- will return the...

The ending ')' is on the last line after where the PK is created.  You need to run the entire script not just where the fields are defined.

I also have a DR site that I log ship to as the logs are dumped from production (every hour).  We use the DR site to populate a Datawarehouse.  We changed the...

It depends.  There are two ways of applying logs to a database, one is to apply them and keep the database in recovery mode, but the problem with that is...