See the following for information about the BACKUP T-SQL command:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/89a4658a-62f1-4289-8982-f072229720a1.htm

Well in this situation I would create the new database where I want the data to go and run something like the following:

DECLARE @object_id int, @schema_id int, @cmd varchar(max), @dbname...

Unless I'm mistaken the script to create the stored procedures in not present in the download.

Is this just me or has anyone else noticed?

Assuming you are using SQL Server 2005:

When the master database is damaged it must be rebuilt if,

A current backup is unavailable or,

A backup exists but can't be restored because, the...

Have you read this,

http://support.microsoft.com/kb/929907

Add a user as an Administrator in the Surface Area Configuration

or use RunAs to open SQL Server Management Studio.

Try looking here,

%Program Files%\Microsoft SQL Server\90\Setup

Bootstrap\LOG\Hotfix\Summary.txt

Could you have just set the collation at a database level?

Changing the default collation for an instance of SQL Server 2005 can be a complex operation and involves the following...

I was of the opinion that both standard edition and enterprise edition supported 50 instances, and workgroup edition supports 16 instances.

Thought that the question was worded incorrectly.

Does anyone agree?

The following gives a step-by-step guide with considerations.

http://msdn.microsoft.com/en-us/library/ms143412(SQL.90).aspx