Examining and Managing SQL 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 Management Studio UI. All SQL CLR objects in a database can be found in the Management Studio Object Explorer window. To find them within the Object Explorer 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 CLR Objects in Object ...

Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.