O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required