Which databases will be able to access the UDT?

You are a database developer on an instance of SQL Server 2008. Your organization has a production database named Prod and a database named Dev that is used by the development team. You want to create a CLR user-defined type (UDT) that will be passed as parameter input to a stored procedure. Using a .NET Framework language, you write and compile the necessary code to create an assembly.
In the Dev database, you register the assembly using a CREATE ASSEMBLY statement and create the type. With no additional actions, which databases will be able to access the UDT?
A. neither the Prod nor Dev database
B. only the Prod database
C. only the Dev database
D. all databases on the SQL Server instance

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.