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
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)
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