Examining and Managing CLR Types in a Database

Once deployed, your SQL CLR stored procedures, functions, triggers, aggregates, and UDTs, and their dependencies, might become difficult to keep track of in your head. Luckily, you can easily perform discovery on deployed SQL CLR entities using the SSDT and SSMS UIs. All SQL CLR objects in a database can be found in the Object Explorer window in SSMS and the SQL Server Object Explorer window in Visual Studio. To find them within either window’s tree view, first navigate to the \servername\Databases\databasename node (where servername and databasename are the names of your server and database, respectively). Refer to Table 3-1 for the subnodes of this node that contain each SQL CLR entity.

Table 3-1. Finding ...

Get Programming Microsoft® SQL Server® 2012 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.