Archive

Archive for the ‘SQL’ Category

How to Install SQL Server 2008 – A Step by Step Guide – Part 2 of 2

December 5th, 2011

Welcome back…

STEP 13 : Server Configuration

This step allows you to set up the service accounts that will be used to run SQL Server. If you have created Windows NT or Active Directory accounts for use with services, use these.

Read more…

SQL

How to Install SQL Server 2008 – A Step by Step Guide – Part 1

December 5th, 2011

A Step by Step guide to installing SQL Server 2008 simply and successfully with no prior knowledge

Read more…

SQL

Saving changes is not permitted (SQL Server 2008)

September 17th, 2010

While creating and editing a database in SQL server 2008 I soon ran into a brick wall, or a ‘by design’ feature of the Database Management Studio.
When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the Database Management Studio will not allow you to save the changes.
This is caused by a configuration setting that default results in the following dialog:

Read more…

SQL