Databases Reference
In-Depth Information
Adding Stored Procedures
Once you have created the stored procedures you can add them to Server
scope assemblies or database scope assemblies. Similar to adding the COM
assembly, you need to use the SQL Server Management Studio to add the
stored procedures. The following steps show how to add a stored procedure:
1. Connect to your database using SQL Server Management Studio.
2. Navigate to your database, right-click the Assemblies folder, and se-
lect New Assembly.
3. You will now be in the register assembly dialog that you used earlier
for adding COM assemblies. Leave the type of the assembly as
.NET assembly and specify the assembly file as shown in
Figure
10-3
.
Figure 10-3
4. Select the option to include debug information so that you can debug
the assembly within the Analysis Server in case you run into prob-
lems. If you click the Details button you will see all the functions that
are part of the assembly as shown in
Figure 10-4
. This is because
.NET assemblies are compiled to an intermediate language and, us-
Search WWH ::
Custom Search