http://www.sqlclr.netRSS feeds for SQLCLR.net60http://www.sqlclr.net/Articles/tabid/54/articleType/ArticleView/articleId/18/Default.aspx#Comments0http://www.sqlclr.net/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=54&ModuleID=371&ArticleID=18http://www.sqlclr.net/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=18&PortalID=0&TabID=54http://www.sqlclr.net/Articles/tabid/54/articleType/ArticleView/articleId/18/Default.aspxIf you choose to implement CLR User Defined Types in SQL Server, there are certain considerations that must be understood to minimize problems later on.  This article covers these considerations and how to plan for them when you are designing the UDT.Jonathan KehayiasMon, 12 May 2008 00:47:00 GMTf1397696-738c-4295-afcd-943feb885714:18http://www.sqlclr.net/Articles/tabid/54/articleType/ArticleView/articleId/10/Using-SQLBulkCopy-in-SQL-CLR.aspx#Comments0http://www.sqlclr.net/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=54&ModuleID=371&ArticleID=10http://www.sqlclr.net/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=10&PortalID=0&TabID=54http://www.sqlclr.net/Articles/tabid/54/articleType/ArticleView/articleId/10/Using-SQLBulkCopy-in-SQL-CLR.aspxAt some point you might want to Bulk Copy data from one database to another, either for archiving, or for reporting.  Whatever your reason, if you choose to implement this with CLR, there is an important gotcha that you need to be aware of.  You can not use SqlBulkCopy with the context connection.Jonathan KehayiasFri, 18 Apr 2008 03:37:00 GMTf1397696-738c-4295-afcd-943feb885714:10