Skip to main content

Posts

Showing posts from November, 2011

Create Visual Studio 2010 SQL Server 2008 Database Project

To create the Visual Studio 2010 SQL Database Project, open the Visual Studio (VS) 2010 as a administrator.  Click on File -> New -> Project : In the opened “New Project” window, under installed templates click on Database -> SQL Server and select “SQL Server 2008 Database Project”, select the location and click “OK” button. Open the solution explorer, you will find the database project has been created with the default folders. Expand Schema Objects folder, expand Schemas folder, expand dbo folder and expand Tables folder. Right click on Tables, select Add -> New Item. In the opened New Item window, select Table and enter the name Books, click Add. Double click on added Books.Table.sql script file and include create table script. Right click on Tables, select Add -> New Item. In the opened New Item window, select Primary Key, enter name and click Add. Open the script file and add script to add primary key for the Books table. You can add other scripts und...

Uninstall ADFS 2.0

To uninstall ADFS 2.0, Go to Control Panel -> Programs -> View Installed Updates.  In the installed updates; look for Active Directory Federation Services under Microsodt Windows updates section. Select ADFS 2.0 and click Uninstall.