SQL Server 2008

0 comments

 

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. 

 

 

SQL

Comments


Leave a Comment