Extracting XML content from an XML file from within SQL Server 2000 using Managed Code

In the previous section, you just completed developing the component.  Now you need to register as COM component and also deploy into GAC cache.  Proceed with the following steps to do this:

• If you didn’t open your Visual Studio command prompt, do it by going to Start -> Programs -> Microsoft Visual Studio.NET 2003 -> Visual Studio.NET tools -> Visual Studio.NET 2003 Command Prompt.
• Go to the “bin” folder of your project folder (which is “Utility”), using the command prompt.
• Type the following command to register the assembly as COM component:

Regasm /tlb:Utility Utility.dll

• After receiving a successful message, again type the following command to get the component registered within GAC cache.

gacutil /I Utility.dll

The screen should look something like the following (Fig1):

That completes your deployment. 

In case you want to unregister the component (say you may want to modify the code after successful registration), you can use the following commands (separately) to do the same (from the same bin folder):