.NET CLR stored procedures in SQL Server 2005 DB: Good News for Programmers, Shock for DBAs - Creating a database project using Visual Studio 2005
(Page 2 of 5 )
Before proceeding further with this article, understand that it focuses on the following suite of products from Microsoft:
· Microsoft SQL Server 2005 Enterprise Edition
· Microsoft Visual Studio 2005 Professional Edition
Let us go through the following steps to create a new data base project using Visual Studio 2005:
· Open Visual Studio 2005 IDE.
· Go to menu File -> New -> Project.
· Within the “New Project” dialog box, select “database” (under visual basic) as the project type and select “SQL Server Project” as the template. Provide your own project name, choose your own location and finally click OK (Figure 1).
· You will be prompted with the “New Database Reference” dialog, where you need to provide the instance name of your SQL Server 2005 installation along with your credentials and database to connect (Figure 2). If only one SQL Server installation has taken place on your system, without any instance name, you can simply provide “.” as the server name. You can test the details by clicking on the “Test Connection” button. Once everything is tested, press OK.
· When you are prompted for “SQL/CLR debugging” (Figure 3) press “YES”.
Once you complete all of these steps, you should be able to see the “server explorer” looking something like this image (Figure 4).
Once you are connected, you can play with all the items existing within the “Server Explorer” along with creating tables, inserting, modifying, deleting, dropping, designing relations, stored procedures (using T-SQL), and so on. Enjoy playing with it; finally, create a new table using “Server explorer” with structure and data as shown in the following figure (Figure 5).
Next: Developing SQL Server 2005 based .NET CLR stored procedure using Visual Studio 2005 >>
More MS SQL Server Articles
More By Jagadish Chaterjee
/ 14 
