SQL Server 2008



1. SQL Server 2008 Database


put installation / migration / usage issues here


2. SQL Server 2008 Management Studio 


For your development machine you do not need to install the full SQL Server 2008 that includes the database engine. You just need the management studio. 


Installing SQL Server 2008 Management Studio


This can be found in Installs at:

I:\Dev\Microsoft SQL Server\Microsoft SQL Server 2008 Management Studio Express


There is a readme.txt file in there that tells you what pre-requisites you need to install first, these include .NET Framework, Windows Installer, Powershell and then finally the Management Studio



Connecting to databases

Connecting to databases is the same as before but you will run into an issue connecting to shared hosting providers like Openhost with the default installed settings. The trouble is with a column called "Collation" which it tries to populate, but we don't have the permissions to access that table.


The fix is the following (provided by Neto and also detailed here: http://sqlblog.com/blogs/aaron_bertrand/archive/2008/07/07/a-little-management-studio-oops.aspx)


- In Object Explorer, click Databases

- Display 'Object Explorer Details' screen (F7 or 'View –> Object Explorer Details')

- Right click the column headers of the window that is displayed (it will probably only contain one item 'Database Snapshots'). This is ( 1 ) in the screenshot below

- Uncheck 'Collation'. This is ( 2 ) in the screenshot





Other Settings

By default you will not be able to make changes to existing tables that result in the table needing to be dropped and recreated.

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box. 





Leave a Comment