Check out GeoNames:

http://www.geonames.org/export/

Can't see anything wrong with it. Make sure you are running this on SQL 2008?!? Also make sure Filestream is enabled for the installation and server properties.

Try

CREATE DATABASE Database1 ON

(FILENAME = N'C:\Temp\Database1.mdf')

FOR ATTACH_REBUILD_LOG

Rob

Sounds like you are expecting the data files to automaticallly shrink, which does not happen unless explicitly set at the database level or requested on an ad-hoc bases.

Try DBCC SHRINKFILE

Use...

Consider:

Clustering - Provide failover to another server should the active server running the database fail (not including SAN). This is not a full DR solution (unless you have a mirrored...

Avoid dynamic SQL, it is not clear here why you need to use it?

Also you do not need to place another EXEC[UTE] as part of the dynamic SQL you are...

Fully Qualified Domain Name (e.g. http://www.google.com)

To use Schema Compare you will need Visual Studio 2010 Ultimate or Database edition.

Rob

I would remove the dependency on the DHCP server and assign static IP addresses for all nodes on the cluster. Keep DHCP for the clients 😉

Robert

You should be able to run sp_depends for all procedures and then query the information schema from these results to find tables and columns that no longer exist.

Rob