Hi folks,

I do not have a backup of the model database and have had to rebuild SQL Server 2000 once already. All my databases except model and tempdb have the collation SQL_Latin1_General_CP1_CI_AS those two have Latin1_General_CI_AS.

During SQL rebuild I've restored over master and msdb and they work fine. Only came across problem with stored procedure and I'm lost as to how to alter model without a backup of it.

Any easy way to change model collation?
The command listed in subject fails as it is a system table.

Is it as simple as going into single user mode and trying that command again?

Help please this is day 3 of my little nightmare.